Palle Girgensohn wrote:
> --On lördag, april 23, 2005 10.10.28 +1200 Oliver Jowett
> <oliver(at)opencloud(dot)com> wrote:
>> Dave Cramer wrote:
>>> Certainly looks like a bug, in the java version mango is not quoted so
>>> pg thinks it is a column.
>>> Although I just checked the test cases and we do this all the time ???
>> The (lack of) quoting is a red herring, it's just how our
>> PreparedStatement.toString() is implemented. The actual query sent uses
>> $1/$2 as you can see in the tcpdump.
> Is there a way to mimic this behaviour, i.e. using a prepared statement
> with $1/$2, in psql?
You could use PREPARE/EXECUTE which is similiar if not identical. From
PREPARE foo(int,varchar) AS SELECT ... $1 ... $2 ...;
EXECUTE foo(42, "bar");
In response to
pgsql-jdbc by date
|Next:||From: Tom Lane||Date: 2005-04-22 22:24:07|
|Subject: Re: BUG? res.next() == false, but psql finds tuples? |
|Previous:||From: Palle Girgensohn||Date: 2005-04-22 22:13:08|
|Subject: Re: BUG? res.next() == false, but psql finds tuples?|