Re: Return a "results set", use a temporary table or use a table?

From: Neil Conway <neilc(at)samurai(dot)com>
To: Hadley Willan <hadley(dot)willan(at)deeper(dot)co(dot)nz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Return a "results set", use a temporary table or use a table?
Date: 2002-10-23 21:27:10
Message-ID: 87smywluc1.fsf@mailbox.samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hadley Willan <hadley(dot)willan(at)deeper(dot)co(dot)nz> writes:
> However, my question is, what is the best way I can use to operate on
> the results that are generated by C. What I mean is A or B will call
> into C and, C will generate a "results set" that A or B need to use.

Try using PostgreSQL 7.3 -- it has much improved support for
set-returning functions ("table functions"), which can be defined in
PL/PgSQL, C, and SQL.

Cheers,

Neil

--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce David 2002-10-23 21:33:45 Trigger on 'create table' ?
Previous Message Richard Ray 2002-10-23 21:26:49 Re: LDAP authentication