Re: CREATE TABLE synopsis

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: CREATE TABLE synopsis
Date: 2005-08-13 02:48:26
Message-ID: 200508130248.j7D2mQm03864@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Right, fixed in create_table.sgml. I don't think it is any other place.

---------------------------------------------------------------------------

Alvaro Herrera wrote:
> The CREATE TABLE synopsis shows this:
>
> CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
> { column_name data_type [ DEFAULT default_expr ] [ column_constraint [ ... ] ]
> | table_constraint
> | LIKE parent_table [ { INCLUDING | EXCLUDING } DEFAULTS ] } [, ... ]
> )
>
> However, we now allow zero-column tables, so it should actually be
>
> CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
> [ column_name data_type [ DEFAULT default_expr ] [ column_constraint [ ... ] ]
> | table_constraint
> | LIKE parent_table [ { INCLUDING | EXCLUDING } DEFAULTS ] ] [, ... ]
> )
>
> Right?
>
> --
> Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-08-13 02:52:34 Patch queue
Previous Message Bruce Momjian 2005-08-13 02:42:36 Re: PL/pgSQL: #option select_into_1_row (was SELECT INTO