Re: Simple row serialization? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Simple row serialization?
Date
Msg-id 8905.1201372824@sss.pgh.pa.us
Whole thread Raw
In response to Re: Simple row serialization?  (Ivan Voras <ivoras@freebsd.org>)
Responses Re: Simple row serialization?  ("Pavel Stehule" <pavel.stehule@gmail.com>)
List pgsql-hackers
Ivan Voras <ivoras@freebsd.org> 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


pgsql-hackers by date:

Previous
From: Ivan Voras
Date:
Subject: Re: Simple row serialization?
Next
From: "Pavel Stehule"
Date:
Subject: Re: Simple row serialization?