Ivan Voras <[EMAIL PROTECTED]> writes:
> Andrew Dunstan wrote:
>> Or you could possibly use some of the XML support in 8.3 for serialization.
> I need this for 8.1 :)
There's an even easier way in 8.3: just cast the rowtype to text.
regression=# select row(1,2,false)::text;
row
---------
(1,2,f)
(1 row)
Although this won't work at the SQL level in 8.1, I think you might be
able to accomplish the equivalent within plpgsql by assigning the
rowtype value to a text variable.
regards, tom lane
---------------------------(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
