Re: How can I expand serialized BLOBs into pseudo columns - Mailing list pgsql-general

Eric Brown wrote:
> 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