| From: | Assad Jarrahian <jarraa(at)gmail(dot)com> | 
|---|---|
| To: | pgsql-general(at)postgresql(dot)org | 
| Subject: | pl/pgsql list as parameter. | 
| Date: | 2005-11-04 18:58:59 | 
| Message-ID: | 4bd3e1480511041058r65c3428eo53170a9a3bf1c457@mail.gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
Hi,
I have a couple questions, I am tryingto write a function that takes as
input a list (size being dynamic) of primaryIDKeys, along with a userdefined
type and returns a set of rows containing those keys. Furthermore the rows
are exactly (columns) like the table that contains the keys, but has an
extra field.((so I define my own tupe)
CREATE FUNCTION somefunc(<how do I declare a list of
ints>,my_predef_type ) RETURNS SETOF tp_lm_object  AS '
DECLARE
..........
How do you take in a list of int? And how would one loop through that?
Much thanks in advance.
-assad
| From | Date | Subject | |
|---|---|---|---|
| Next Message | vishal saberwal | 2005-11-04 19:25:46 | Re: Image File System Question | 
| Previous Message | Peter Filipov | 2005-11-04 18:08:43 | I just can't get it:record_in, record_out(I know i try to do something postgres is not developed for but there are many 'buts') |