Gregory Stark ha scritto:
"Nico Sabbi" <nsabbi@xxxxxxxxxxxxxxxxxxx> 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;
yes, it works.
Thanks a lot,
Nico
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
