Re: a column definition list is required for functions returning "record" - Mailing list pgsql-general

From Tom Lane
Subject Re: a column definition list is required for functions returning "record"
Date
Msg-id 2922.1473287966@sss.pgh.pa.us
Whole thread Raw
In response to Re: a column definition list is required for functions returning "record"  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-general
Jim Nasby <Jim.Nasby@BlueTreble.com> writes:
> On 9/7/16 2:02 PM, Merlin Moncure wrote:
>> We have that already, it's named 'json_each_text'

> Apparently you haven't looked at json parse/deparse costs ;P

Well, a PL function is gonna be none too cheap either.

Using something like JSON definitely has lots to recommend it --- eg, it
probably won't break when you find out your initial spec for the transport
format was too simplistic.

            regards, tom lane


pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: How to assemble all fields of (any) view into a string?
Next
From: Tom Lane
Date:
Subject: Re: How to assemble all fields of (any) view into a string?