pl/pgsql list as parameter.

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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')