Hi,
is there any way to cast a generic row to an array or to a table type?
The example is trivial, but it explains what I'm trying to do:
nb1=# select * from tab1;
a | t
---+---
1 | a
2 | b
3 | c
(3 rows)
nb1=# select r from (select row(tab1.*) as r from tab1)x;
r
-------
(1,a)
(2,b)
(3,c)
(3 rows)
nb1=# select r[1] from (select row(tab1.*) as r from tab1)x;
ERROR: cannot subscript type record because it is not an array
nb1=# select (r::tab1).a from (select row(tab1.*) as r from tab1)x;
ERROR: cannot cast type record to tab1
The real use case is much more complex than this example of course :)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
