Re: IN clauses via setObject(Collection) [Was: Re: Prepare

>
>
>So, yes you should be able to create a set datatype and pass that into the
>PreparedStatment (JDBC allows for this using the SQLData interface, I don't know
>if postgresql supports it),
>
I know, that it doesn't

> but the data that is representing a set datatype
>would not be able to be inserted where SQL set Syntax is expected.
>
Why the hell not???

>  The set
>datatype and the SQL set Syntax are completely distinct objects.
>
>
An int datatype and an int syntax are two distinct objects too :-)
That's precisely the job of the JDBC driver to convert datatypes I pass
in into their representation with the correct syntax that backend would
understand.

I would have no use of the driver doing anything else - what's the point
in passign data in if the syntax it gets converted into isn't understood
by the server?

Dima