Re: the IN clause saga - Mailing list pgsql-jdbc

From Fernando Nasser
Subject Re: the IN clause saga
Date
Msg-id 3F1D5168.30806@redhat.com
Whole thread Raw
In response to Re: the IN clause saga  (Darin Ohashi <DOhashi@maplesoft.com>)
Responses Re: the IN clause saga  (Joe Conway <mail@joeconway.com>)
List pgsql-jdbc
Darin Ohashi wrote:
>>Oliver has to update his summary first.  There are some new info from
>>the backend side.
>>
>>Note that option 2 now should read "when inside the parenthesis that
>>define an <in value list> of the IN <predicate>.  (I am using the SQL
>>standard clause names here).
>>
>>I would go with number 2 because that is exactly what the
>>backend does
>>in its PREPARE statement.
>
>
> I'm not sure if this makes sense, but could you have a conflict between a set
> containing a single element that is the array and a set containing the elements
> of the array.
>

You will need to have an Array of Arrays in that case.


--
Fernando Nasser
Red Hat Canada Ltd.                     E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9


pgsql-jdbc by date:

Previous
From: Fernando Nasser
Date:
Subject: Re: patch: tiny patch to correct stringbuffer size estimate
Next
From: Felipe Schnack
Date:
Subject: Re: patch: tiny patch to correct stringbuffer size estimate