Re: the IN clause saga

Darin Ohashi wrote:
>>>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.
>>
>
>
> Will this requirement violate the SQL standard for PREPARE/EXECUTE?
>

PREPARE is not a Core SQL statement, it is only defined for embedded SQL
(like for the C language).  The PostgreSQL prepare statement is an
extension as it can be used interactively and has it is own syntax that
is _way_ better than what is used on DB2 for instance (where types have
to be guessed based on a brain damaged long set of rules).



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