Received: from barb.worldchat.com (root@barb.wchat.on.ca [204.138.239.65]) by hub.org (8.8.8/8.7.5) with ESMTP id RAA25472 for ; Mon, 1 Jun 1998 17:14:26 -0400 (EDT) Received: from wchat.on.ca (rlan1-p40.wchat.on.ca [205.210.137.56]) by barb.worldchat.com (8.8.8/8.7.3) with ESMTP id RAA07042 for ; Mon, 1 Jun 1998 17:14:19 -0400 (EDT) Sender: danielf@worldchat.com Message-ID: <35731A35.18CD52F6@wchat.on.ca> Date: Mon, 01 Jun 1998 17:16:38 -0400 From: "Daniel W. Forsyth" Organization: DATAFORGE X-Mailer: Mozilla 4.03 [en] (X11; I; Linux 2.0.30 i586) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: SELECT Command? Messed again? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi there, I'm currently using 6.3. When I issue the command SELECT * FROM client_database WHERE client ~~ '%%' it displays nobody, when i use 6.1 it works fine, as %% or %%%% defaults to every entry? Does anyone know what is going on? PS: Please help, the companies client database is quite important :-). Thanks -- Daniel W. Forsyth DATAFORGE PHONE: 905-632-9918 FAX: 905-632-1907