Re: the IN clause saga

From: Fernando Nasser <fnasser(at)redhat(dot)com>
To: Darin Ohashi <DOhashi(at)maplesoft(dot)com>
Cc: Felipe Schnack <felipes(at)ritterdosreis(dot)br>, Oliver Jowett <oliver(at)opencloud(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: the IN clause saga
Date: 2003-07-22 14:59:52
Message-ID: 3F1D5168.30806@redhat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)redhat(dot)com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Felipe Schnack 2003-07-22 15:05:45 Re: patch: tiny patch to correct stringbuffer size estimate
Previous Message Fernando Nasser 2003-07-22 14:57:58 Re: patch: tiny patch to correct stringbuffer size estimate