SELECT expandobj(obj), * from mytable; I get: ERROR: cannot display a value of type record
I think/hope I'm missing something pretty stupid, but I can't figure out what it might be. Any help would be appreciated. There might even be a quite better way.
What you're trying to do isn't supported in 7.4 and earlier. Works in 8.0.0 (which just went RC1) though:
regression=# SELECT expandobj(obj), * from mytable; -- this does not expandobj | id | obj -----------+----+----- (x,y) | 1 | x,y (1 row)
and so does:
regression=# SELECT (expandobj(obj)).val1, (expandobj(obj)).val2, * from mytable;
val1 | val2 | id | obj
------+------+----+-----
x | y | 1 | x,y
(1 row)
HTH,
Joe
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org