Re: NEED URGENT HELP....

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Henrique P Machado <zehrique(at)gmail(dot)com>
Cc: Guy Rouillier <guyr-ml1(at)burntmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: NEED URGENT HELP....
Date: 2006-12-26 11:53:48
Message-ID: 20061226115348.GB8412@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general pgsql-sql

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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Gurjeet Singh 2006-12-26 15:09:01 Re: NEED URGENT HELP....
Previous Message Thomas Jahnsen 2006-12-26 10:21:41 Re: BUG #2838: Compile error "tab-complete.c" on Mac OS X

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2006-12-26 12:11:51 Re: Does pgsql's regex processor optimize Common-Prefix?
Previous Message karthik 2006-12-26 10:43:17 could not open relation:no such file or directory

Browse pgsql-sql by date

  From Date Subject
Next Message Gurjeet Singh 2006-12-26 15:09:01 Re: NEED URGENT HELP....
Previous Message Jan Andersen 2006-12-26 10:54:14 Re: Related tables to a view