Mel Roman <f24012(at)yahoo(dot)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
Next:From: Oliver ElphickDate: 2002-01-11 11:15:04
Subject: Re: Table with default value
Previous:From: Mel RomanDate: 2002-01-11 04:52:10
Subject: How do you do a subselect in postgresql?