* 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