pl/pgsql list as parameter. - Mailing list pgsql-general

From Assad Jarrahian
Subject pl/pgsql list as parameter.
Date
Msg-id 4bd3e1480511041058r65c3428eo53170a9a3bf1c457@mail.gmail.com
Whole thread Raw
Responses Re: pl/pgsql list as parameter.  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: pl/pgsql list as parameter.  (David Gagnon <dgagnon@siunik.com>)
List 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

pgsql-general by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: Image File System Question
Next
From: vishal saberwal
Date:
Subject: Re: Image File System Question