From: Daniel Myers <danielsmyers@gmail.com>
To: pgsql-sql@postgresql.org
Subject: PL/pgsql: function passing argument to IN operator
Date: Sat, 29 Dec 2007 01:40:03 -0500
Message-ID: <455d64770712282240h3c93a2f0y9e357d1d23882b10@mail.gmail.com> (raw)
Hello list,
I'm trying to write a function that uses one of its arguments as
an input to an IN operator in a WHERE clause. I.e., something like:
-- ids are actually integers
CREATE FUNCTION foo(ids SOMETYPE) RETURNS [whatever] AS $$
BEGIN
SELECT id, [other stuff] FROM table WHERE [other conditions] AND
id IN (ids);
RETURN;
END
$$ plpgsql
I had wanted to avoid using the EXECUTE statement and dynamically
creating the query string, because 1) I'd rather not recompile the
query each time and 2) I'm doing a SELECT INTO, which apparently
doesn't work with EXECUTE.
Can anyone help me out?
Thanks,
Daniel
P.S.: Sorry if capitalizing SQL keywords is bad list etiquette...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: danielsmyers@gmail.com
Subject: Re: PL/pgsql: function passing argument to IN operator
In-Reply-To: <455d64770712282240h3c93a2f0y9e357d1d23882b10@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox