Re: Function returns composite type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Teodor Sigaev <teodor(at)sigaev(dot)ru>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Function returns composite type
Date: 2003-06-10 13:45:52
Message-ID: 2190.1055252752@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Teodor Sigaev <teodor(at)sigaev(dot)ru> writes:
> For some reason I wish to write C-function for SQL which returns set of
> composite type, but this type is defined function itself and composite type can
> be changed from call to call. So I can't define create type by 'CREATE TYPE'
> command.

Perhaps the RECORD stuff would help you? It's poorly documented, but
you could look at the code for SRFs to see how to use it.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jon Jensen 2003-06-10 13:46:04 Re: host and hostssl equivalence in pg_hba.conf
Previous Message Tom Lane 2003-06-10 13:42:16 Re: host and hostssl equivalence in pg_hba.conf