Re: row->ARRAY or row->table casting?

[Gregory Stark <stark(at)enterprisedb(dot)com>]

"Nico Sabbi" <nsabbi(at)officinedigitali(dot)it> 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