Tom Lane <[EMAIL PROTECTED]> writes:

> select * from (select 1 as foo, 2 as foo) as x(foo1, foo2);

How is this different than simply listing all the columns instead of the "*"?

I still have the maintenance problem of having to edit the outer query every
time the list of columns from the inner query changes.

-- 
greg


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to