thanks David for the explanation
how would you use the function then in a select statement, i couldn=E2=80=99=
t get it to work?
On Jul 7, 2016, at 03:58, David G. Johnston <david.g.johnston@gmail.com> =
wrote:
On Wednesday, July 6, 2016, <aouda.h@me.com <mailto:aouda.h@me.com>> =
wrote:
The following bug has been logged on the website:
Bug reference: 14232
Logged by: Hicham Aouda
Email address: aouda.h@me.com <javascript:;>
PostgreSQL version: 9.5.3
Operating system: All
Description:
On page 1151 43.3.4. Composite Types
of the pdf documentation for 9.5.3
I suspect a mistake:
it should be :
CREATE TYPE employee AS (
name text,
salary integer,
age integer );
and not
CREATE TABLE employee (
name text,
salary integer,
age integer );
It's functionally correct. Every table you create automatically has a =
type of the same name and structure.
David J.=20