Tom Lane ha scritto:
Nico Sabbi <[EMAIL PROTECTED]> writes:
is there any way to cast a generic row to an array or to a table type?

"row(...)::composite_type" should work in 8.2 and up.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

I'm using 8.2.4.

What's the right syntax for a case like this?

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.

Thanks,
   Nico

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to