From: | Hicham AOUDA <aouda(dot)h(at)me(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #14232: Possible mistake in the documentation |
Date: | 2016-07-07 01:00:00 |
Message-ID: | E96AE51F-5776-42ED-9102-4D73EBD3F983@me.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2016-07-07 01:15:04 | Re: BUG #14232: Possible mistake in the documentation |
Previous Message | David G. Johnston | 2016-07-07 00:58:53 | Re: BUG #14232: Possible mistake in the documentation |