prepared statement: are they pre-compiled? - Mailing list pgsql-jdbc

From Flipper
Subject prepared statement: are they pre-compiled?
Date
Msg-id 200707051023.25650.flipper@gammadue.com
Whole thread Raw
Responses Re: prepared statement: are they pre-compiled?  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-jdbc
Hi all,
a little question about prepared statement. I know that one advantage of using
prepared statement is the fact that the statament could be "precompiled" by
the server before the binding of parameters, is it true?
But while observing the messages sent from the FE to the BE by the postgresql
driver, I noticed that the query is sent along with the bind of the
parameters, that is the when the executeQuery() method is called on the
prepared statement, both the parse and bind messages are sent. I thought the
bind message have to be sent before the bind one, but it seems to me it's
not. Anyone can please help me understand this?

Thanks.

pgsql-jdbc by date:

Previous
From: Andrew Lazarus
Date:
Subject: NULL as an element of an ARRAY
Next
From: Heikki Linnakangas
Date:
Subject: Re: prepared statement: are they pre-compiled?