"David Johnston" <pol...@yahoo.com> writes: > More simply if you run any query of the form: > SELECT subquerycolumn > FROM ( > SELECT subquerycolumn FROM table WHERE [condition] FOR UPDATE -- WHERE > is optional but obviously useful; FOR SHARE also causes this behavior > ) intermediate > The error "cannot extract system attribute from virtual tuple" is thrown IIF > the sub-query returns one or more records.
Fixed, thanks for the report! http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=d5478c3391f8f1a243abbc3d9253aac3d6d3538e regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
