From: | Christopher Murtagh <christopher(dot)murtagh(at)mcgill(dot)ca> |
---|---|
To: | "'PostgreSQL General'" <pgsql-general(at)postgresql(dot)org> |
Subject: | PL/Perl returning multiple rows |
Date: | 2003-11-10 20:59:53 |
Message-ID: | 1068497992.348.41.camel@brahma.wcg.mcgill.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Greetings,
I'm trying to write a pl/perl function that will return multiple rows.
I've looked all over the web and only found vague references as to how
to do this (some said it was possible, and some said it wasn't but it
was for older versions of Postgres).
Basically I would *love* to be able to do something like this:
SELECT some_id
FROM some_table
WHERE ....
INTERSECT
SELECT perlfunc(someparameter);
Is this possible, or do I need to insert results into a temporary table
and intersect with that?
SELECT some_id
FROM some_table
WHERE ....
INTERSECT
SELECT some_id
FROM temp_result
WHERE temp_id = perlfunc(someparameter);
Any pointers would be much appreciated.
Thanks in advance.
Cheers,
Chris
--
Christopher Murtagh
Enterprise Systems Administrator
ISR / Web Communications Group
McGill University
Montreal, Quebec
Canada
Tel.: (514) 398-3122
Fax: (514) 398-2017
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Smith | 2003-11-10 21:29:44 | ERROR: out of free buffers: time to abort! |
Previous Message | Boris Popov | 2003-11-10 20:58:34 | Re: Temp rows - is it possible? |