Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 8E19F636358 for ; Thu, 11 Mar 2010 12:38:36 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 20667-07-2 for ; Thu, 11 Mar 2010 16:38:26 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id 197A9635CD2 for ; Thu, 11 Mar 2010 12:38:14 -0400 (AST) Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Thu, 11 Mar 2010 10:38:13 -0600 Message-Id: <4B98C80D020000250002FC74@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Thu, 11 Mar 2010 10:38:05 -0600 From: "Kevin Grittner" To: , Subject: =?ISO-8859-15?Q?Re:=20=20select=20(\'*\'=20~*=20\'*\')=3D?= =?ISO-8859-15?Q?true=20=20while=20select=20(\'*\'=20ilike=20\'*\')=20?= References: <4b86bdeb03d3c8.17572985@freemail.gr> In-Reply-To: <4b86bdeb03d3c8.17572985@freemail.gr> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/77 X-Sequence-Number: 33876 wrote: > I have a freshly compiled installation of postresql on ubuntu > 9.10. What PostgreSQL version? Compiled with what configuration options? > encoding is set correctly. To what? With what character set, collation, etc.? You've posted some of the information needed to understand the problem, but please review this for ideas on what else might help people identify the cause: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems -Kevin