Re: BUG? res.next() == false, but psql finds tuples?

Palle Girgensohn wrote:
> --On lördag, april 23, 2005 10.10.28 +1200 Oliver Jowett
> <oliver@opencloud.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
memory:

  PREPARE foo(int,varchar) AS SELECT ... $1 ... $2 ...;
  EXECUTE foo(42, "bar");

-O