Re: How to assemble all fields of (any) view into a string?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>
Cc: Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to assemble all fields of (any) view into a string?
Date: 2016-09-07 22:46:10
Message-ID: 3200.1473288370@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> writes:
> On 9/7/16 5:32 PM, Ken Tanzer wrote:
>> I know TCL and probably Python and others can work with a record as a
>> trigger function. But TCL doesn't seem to accept a record as an
>> argument. Can any of the other languages that could also accomplish
>> this function? Or some other way? Thanks.

> A PL that can accept composite types (such as plpythonu) should be able
> to do this.

I think pltcl is actually the only one of our standard PLs that can't take
"record". There's no intrinsic reason for that, it just hasn't gotten the
love the other PLs have.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-09-07 22:46:53 Re: How to assemble all fields of (any) view into a string?
Previous Message Tom Lane 2016-09-07 22:39:26 Re: a column definition list is required for functions returning "record"