Re: JDBC, prepared queries, and partitioning

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: josh(at)agliodbs(dot)com, Stephen Denne <Stephen(dot)Denne(at)datamail(dot)co(dot)nz>, Kris Jurka <books(at)ejurka(dot)com>, PostgreSQL - JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: JDBC, prepared queries, and partitioning
Date: 2008-02-14 07:18:19
Message-ID: 47B3EB3B.5050605@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Simon Riggs wrote:

> But V3 supports having no parameters at all right?

Yes, but you're missing the point. If you want to, for example, ask for
metadata about the 4th parameter to the query, there has to *be* a 4th
parameter. If you fold everything inline, you lose the various
advantages that having the parameters out of line give you, such as the
ability to query the server about their characteristics or stream their
actual values in a binary form separate to the query, etc.

-O

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Simon Riggs 2008-02-14 07:43:33 Re: JDBC, prepared queries, and partitioning
Previous Message Simon Riggs 2008-02-14 07:13:23 Re: JDBC, prepared queries, and partitioning