Re: [HACKERS] docs: WITH queries and VALUES

2012-04-14 Thread Peter Eisentraut
On tor, 2012-04-12 at 11:59 +0200, Magnus Hagander wrote: The SELECT manpage has: and with_query is: 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

Re: [HACKERS] docs: WITH queries and VALUES

2012-04-14 Thread Magnus Hagander
On Apr 14, 2012 8:09 AM, Peter Eisentraut pete...@gmx.net wrote: On tor, 2012-04-12 at 11:59 +0200, Magnus Hagander wrote: The SELECT manpage has: and with_query is: with_query_name [ ( column_name [, ...] ) ] AS ( select | insert | update | delete ) Should that list that

[HACKERS] docs: WITH queries and VALUES

2012-04-12 Thread Magnus Hagander
The SELECT manpage has: and with_query is: 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

Re: [HACKERS] docs: WITH queries and VALUES

2012-04-12 Thread Stephen Frost
* Magnus Hagander (mag...@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

Re: [HACKERS] docs: WITH queries and VALUES

2012-04-12 Thread Tom Lane
Stephen Frost sfr...@snowman.net writes: * Magnus Hagander (mag...@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