Re: union in subselect? - Mailing list pgsql-sql

Gary Stainburn <gary.stainburn@ringways.co.uk> writes:
> select * from actions where cposn in (select posn from positions where pholder
> = 81 union select 'NEC' as posn from members where mnec = true and mid = 81);

> gives me:
> ERROR:  parser: parse error at or near "union" 

Update to PG 7.1.
        regards, tom lane