Simple function question

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: Postgres <pgsql-novice(at)postgresql(dot)org>
Subject: Simple function question
Date: 2004-10-26 11:12:36
Message-ID: F0DB4D94-273F-11D9-A778-000A95D7BA10@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I would like to create a function that accepts an array of IDs
(integers) and loops over them, returning the the rows (setof
rowtype...?) that match them. I have tried to no avail to form such a
function. As a final extension, I would like to be able to return rows
formed by a join across a few tables (return a setof RECORD type?). I
suppose I can just create the view I like then use a similar function
to the single-table version....

Thanks,
Sean

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2004-10-26 12:29:13 Re: Simple function question
Previous Message Steven Klassen 2004-10-26 03:46:36 Re: Function to convert bigint to date