Received: from smtp2.jakinternet.co.uk (proxy.jakinternet.co.uk [212.41.43.4]) by hub.org (8.10.1/8.10.1) with ESMTP id e6G8bM059530 for ; Sun, 16 Jul 2000 04:37:22 -0400 (EDT) Received: from smtp.jakinternet.co.uk (smtp.jakinternet.co.uk [212.41.41.61]) by smtp2.jakinternet.co.uk (Postfix) with SMTP id F41E3A7767 for ; Sun, 16 Jul 2000 09:36:02 +0100 (BST) Received: from tabatha ([212.41.52.95]) by smtp.jakinternet.co.uk ; Sun, 16 Jul 2000 09:37:03 -0100 Message-ID: <008a01bfef01$398b4ee0$5f3429d4@retep.org.uk> From: "Peter Mount" To: "Matt Fair" , References: <3970A8C4.6B2DBE3A@netasol.com> Subject: Re: JDBC Query bug Date: Sun, 16 Jul 2000 09:36:16 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200007/102 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 To: 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 >