"Nico Sabbi" <[EMAIL PROTECTED]> writes: > nb1=# select r.a from (select row(tab1.*)::tab1 as r from tab1)x; > ERROR: missing FROM-clause entry for table "r" > LINE 1: select r.a from (select row(tab1.*)::tab1 as r from tab1)x; > ^ > I tried many variations (including casting x as tab1) obtaining only syntax > errors.
r.a would be the column "a" in the table named "r", but the only table in the FROM list is "x". So you have to use a workaround to make it clear to the parser that you're referring to the column "r", it would look like SELECT (r).a from (select row(tab1.*)::tab1 as r from tab1)x; -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
