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