Re: NEED URGENT HELP.... - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: NEED URGENT HELP....
Date
Msg-id 20061226115348.GB8412@svana.org
Whole thread Raw
In response to Re: NEED URGENT HELP....  ("Henrique P Machado" <zehrique@gmail.com>)
Responses Re: NEED URGENT HELP....  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
Re: NEED URGENT HELP....  (Iannsp <iannsp@gmail.com>)
List pgsql-general
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.

Attachment

pgsql-general by date:

Previous
From: vinayakr@vmoksha.com
Date:
Subject: DB problem
Next
From: Alvaro Herrera
Date:
Subject: Re: Does pgsql's regex processor optimize Common-Prefix?