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 what comes up when you do \h WITH, so I
got the question of "why is values not supported for with". but it
is..)
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/