It works Martijn...
but with a few changes will be required in your function Sandip; you will have to pass an ARRAY constructor and return a SETOF record. Here's a sample:
postgres=> create table tab ( a int, b int );CREATE TABLEpostgres=> insert into tab values ( 1, 9 );INSERT 0 1postgres=> insert into tab values (2,8);INSERT 0 1postgres=> insert into tab values (3,7);INSERT 0 1postgres=> insert into tab values (4,6);INSERT 0 1postgres=> insert into tab values (5,5);INSERT 0 1postgres=> create or replace function fun ( character varying [] ) returns setof tab aspostgres-> $$postgres$> select * from tab where a = any ($1)postgres$> $$ language 'sql' volatile;CREATE FUNCTIONpostgres=> select fun('{1}'); fun------- (1,9)(1 row)postgres=> select fun('{2,3}'); fun------- (2,8) (3,7)(2 rows)postgres=> Hope it helps....
On 12/26/06, Martijn van Oosterhout <kleptog@svana.org> wrote: On Mon, Dec 25, 2006 at 08:52:52PM -0300, Henrique P Machado wrote:
> WHERE (USER_ID = $1) AND (COMPANY_ID = $2) AND BOOK_NO IN ($3)
>
> Could'nt he use an array in this 3rd parameter?
I think so, if it's written:
AND BOOK_NO = ANY($3)
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
iD8DBQFFkQ1LIB7bNG8LQkwRApbCAJsH26IcDusO5Vi5kNC1UQ185usbnACeOxdC
xQo+z5Z7+Xofks/h3MmeF7w=
=Rq6g
-----END PGP SIGNATURE-----
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | yahoo }.com
