Re: [GENERAL] How can I expand serialized BLOBs into pseudo columns

2004-12-04 Thread Joe Conway
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 i

[GENERAL] How can I expand serialized BLOBs into pseudo columns

2004-12-04 Thread Eric Brown
I have a table (quite a few of them actually) where python objects are serialized into a column. So a table might look like: CREATE TABLE mytable (id int, obj bytea); When I'm trying to diagnose/debug things, I'd like to be able to expand the 'obj' column into multiple columns in a view. I create