From: Peter Mount <peter@retep.org.uk>
To: Matt Fair <matt@netasol.com>
To: pgsql-interfaces@postgreSQL.org
Subject: Re: JDBC Query bug
Date: Sun, 16 Jul 2000 09:36:16 +0100
Message-ID: <008a01bfef01$398b4ee0$5f3429d4@retep.org.uk> (raw)
References: <3970A8C4.6B2DBE3A@netasol.com>
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@retep.org.uk, peter@retepdigital.com, me@petermount.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@netasol.com>
To: <pgsql-interfaces@postgreSQL.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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: peter@retep.org.uk, matt@netasol.com
Subject: Re: JDBC Query bug
In-Reply-To: <008a01bfef01$398b4ee0$5f3429d4@retep.org.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox