Re: BUG #14232: Possible mistake in the documentation

thanks David for the explanation
how would you use the function then in a select statement, i couldn’t get it to work?

On Jul 7, 2016, at 03:58, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

On Wednesday, July 6, 2016, <aouda(dot)h(at)me(dot)com <mailto:aouda(dot)h(at)me(dot)com>> wrote:
The following bug has been logged on the website:

Bug reference: 14232
Logged by: Hicham Aouda
Email address: aouda(dot)h(at)me(dot)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.