Received: from mail.archeanit.net ([202.9.184.27]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4E4e0A42622 for ; Mon, 14 May 2001 00:40:01 -0400 (EDT) (envelope-from shiva@archeanit.com) Received: (qmail 1866 invoked from network); 13 May 2001 16:43:59 -0000 Received: from unknown (HELO archeanit.com) (127.0.0.1) by 127.0.0.1 with SMTP; 13 May 2001 16:43:59 -0000 Received: from 192.168.0.2 (SquirrelMail authenticated user shiva) by mail.archeanit.net with HTTP; Sun, 13 May 2001 22:13:59 +0530 (IST) Message-ID: <1032.192.168.0.2.989772239.squirrel@mail.archeanit.net> Date: Sun, 13 May 2001 22:13:59 +0530 (IST) Subject: how to remove ? From: "Subhramanya Shiva" To: pgsql-sql@postgresql.org In-Reply-To: <22976.989725464@sss.pgh.pa.us> References: <22976.989725464@sss.pgh.pa.us> X-Mailer: SquirrelMail (version 0.5) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200105/121 X-Sequence-Number: 2937 How to remove from this mailing list ? > "Marc Lamothe" writes: > > The subnet_number column is a varchar(16) which I assume you can compare > > with a text data type, which is what host() returns. > > Are you on a pre-7.1 Postgres release? host() is buggy before 7.1 --- > it includes a trailing null in its output, which it shouldn't oughta > have done. You can't see the null from outside the system, but it > manages to mess up text comparisons anyway. > > BTW, you should consider using inet or cidr datatype for that column > rather than varchar... > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > -- Subhramanya Shiva, Programmer Archean InfoTech pvt.Ltd. Hyderabad, India http://www.archeanit.com