Re: [HACKERS] docs: WITH queries and VALUES

2012-04-14 Thread Magnus Hagander
On Apr 14, 2012 8:09 AM, "Peter Eisentraut" 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

Re: [HACKERS] docs: WITH queries and VALUES

2012-04-13 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 con

Re: [HACKERS] docs: WITH queries and VALUES

2012-04-12 Thread Tom Lane
Stephen Frost 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 use valu

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 in

[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