Postgres Pro
Downloads
Home   >   mailing lists

Re: postgresql-8.0.jar and failure of ORDER BY parameters - Mailing list pgsql-jdbc

From Xavier Poinsard
Subject Re: postgresql-8.0.jar and failure of ORDER BY parameters
Date
Msg-id 4278DF49.3050006@free.fr
Whole thread Raw
In response to Re: postgresql-8.0.jar and failure of ORDER BY parameters  (Guillaume Cottenceau <gc@mnc.ch>)
List pgsql-jdbc
Tree view 
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.

pgsql-jdbc by date:

Previous
From: Guillaume Cottenceau
Date:
Subject: Re: postgresql-8.0.jar and failure of ORDER BY parameters
Next
From: Tom Lane
Date:
Subject: Re: postgresql-8.0.jar and failure of ORDER BY parameters