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 17:33:35 |
Message-ID: | 3F1D756F.7030706@redhat.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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(at)redhat(dot)com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9
From | Date | Subject | |
---|---|---|---|
Next Message | Fernando Nasser | 2003-07-22 17:35:37 | Re: the IN clause saga |
Previous Message | Darin Ohashi | 2003-07-22 17:32:32 | Re: the IN clause saga |