Re: How do you do a subselect in postgresql?

Mel Roman <f24012@yahoo.com> writes:
> meltest=>select * from (select * from weather) as w;
> ERROR:  parser: parse error at or near "select"

This works since 7.1.  Apparently you have an old version...

            regards, tom lane