Re: postgresql-8.0.jar and failure of ORDER BY parameters

From: "Xavier Poinsard" <xpoinsard(at)free(dot)fr>
To:
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: postgresql-8.0.jar and failure of ORDER BY parameters
Date: 2005-05-04 14:42:17
Message-ID: 4278DF49.3050006@free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Guillaume Cottenceau wrote:
> Is there any way to give parameters to ORDER BY in a
> preparedStatement then?

This seems impossible since the aim of the preparedStatement is the
caching of the execution plan which is affected by the ORDER BY clause.
The same reason applies for table name or columns names.
The parameters should be real parameters, not part of the query structure.

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2005-05-04 14:50:36 Re: postgresql-8.0.jar and failure of ORDER BY parameters
Previous Message Guillaume Cottenceau 2005-05-04 14:30:18 Re: postgresql-8.0.jar and failure of ORDER BY parameters