Re: docs: WITH queries and VALUES - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: docs: WITH queries and VALUES
Date
Msg-id 20120412100825.GM1267@tamriel.snowman.net
Whole thread Raw
In response to docs: WITH queries and VALUES  (Magnus Hagander <magnus@hagander.net>)
Responses Re: docs: WITH queries and VALUES  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
* Magnus Hagander (magnus@hagander.net) wrote:
>     with_query_name [ ( column_name [, ...] ) ] AS ( select | insert |
> update | delete )
>
>
> Should that list that you can use values as well? Or is it something
> we generally consider "wherever select works you can use values"?
>
> (I ran into it because it's what comes up when you do \h WITH, so I
> got the question of "why is values not supported for with". but it
> is..)

TABLE also works there, and here:
[ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] select ]

and here:
( select ) [ AS ] alias [ ( column_alias [, ...] ) ]

Not sure if it's worth fixing, just something I noticed.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: docs: WITH queries and VALUES
Next
From: Bruce Momjian
Date:
Subject: Re: Last gasp