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

--On fredag, april 22, 2005 11.01.32 -0400 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
wrote:

> Dave Cramer <pg(at)fastcrypt(dot)com> writes:
>> Certainly looks like a bug, in the java version mango is not quoted so
>> pg thinks it is a column.
>
> But that's just sloppiness in the java log message. The TCP dump shows
> clearly that the values are being sent as $n parameters.
>
> I'm wondering about misassignment of data types or something. It's not
> clear though how that would result in no error but zero rows returned.
> What are the column data types exactly?

userid is text (setInt())
courseid is int (setString())

lang is text

Interesting that the int is transported as text, `38', but I guess there
are very good reasons for this (not having to duplicate code in the jdbvc
driver, different endians, etc).

There is no error in the pgsql log, just no result. The same connection is
beeing used for all queries. It is reproducable, every time, in our app.

/Palle