Re: JDBC Query bug

Probably the backend. What do you get if you run this query from psql?

JDBC currently does nothing to the SQL before passing it to the backend.

Peter

--
Peter T Mount peter(at)retep(dot)org(dot)uk, peter(at)retepdigital(dot)com, me(at)petermount(dot)com
Homepage: http://www.retep.org.uk Contact details @ http://petermount.com
PostgreSQL JDBC: http://www.retep.org.uk/postgres/
Java PDF generator: http://www.retep.org.uk/pdf/

----- Original Message -----
From: Matt Fair <matt(at)netasol(dot)com>
To: <pgsql-interfaces(at)postgreSQL(dot)org>
Sent: Saturday, July 15, 2000 7:09 PM
Subject: [INTERFACES] JDBC Query bug

> This jdbc is messing up on basic select/where queries. For example:
> SELECT usename FROM pg_user WHERE usename ~* 'star_.*';
>
> usename
> ---------
> star_admin
>
> But in jdbc I do:
>
> SELECT usename FROM pg_user WHERE usename ~* 'star_.*';
>
> I get an empty result set.
> rs.next() is false.
>
> What would be causing this?
> Matt
>