Re: Binary tx format for an array?

On Fri, 2006-06-23 at 15:46 -0500, Kris Jurka wrote:
> > As far as I can tell from reading the JDBC CVS code, the sequence for
> > preparing and executing a statement for the first time is:
> >
> > PREPARE            (name=my_statement)
> > DESCRIBE STATEMENT (name=my_statement)
> > SYNC/FLUSH
> > Read Responses
> >
> > BIND               (portal=my_portal)
> > DESCRIBE PORTAL    (name=my_portal)
> > EXECUTE            (portal=my_portal)
> > SYNC/FLUSH
> > Read Responses
> >
>
> Nope. There is no Sync in the middle there.  The driver sends Parse,
> Describe Statement, Bind, Execute, Sync all at once.  You may be confused
> by the driver's ability to Parse/Describe/Sync a query to implement
> ParameterMetaData, but that's an unusual operation, not the normal path.

Ah, yes that's where I was confused.  Now I understand why it was such a
pain to support things like timestamp with/without timezone; you don't
get the describe statement back until you've already run the BIND.

-- Mark