Received: from junk.nocrew.org ([212.73.17.42]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0HDdo017758 for ; Wed, 17 Jan 2001 08:39:50 -0500 (EST) (envelope-from rojo@junk.nocrew.org) Received: from rojo by junk.nocrew.org with local (Exim 3.12 #1 (Debian)) for pgsql-sql@postgresql.org id 14IsoU-00053m-00; Wed, 17 Jan 2001 14:39:46 +0100 To: pgsql-sql@postgresql.org Subject: sort order with < & > in varchar fields From: Rolf Johansson Date: 17 Jan 2001 14:39:46 +0100 Message-ID: <7jhf2yfgbh.fsf@junk.nocrew.org> Lines: 13 User-Agent: Gnus/5.0803 (Gnus v5.8.3) Emacs/20.7 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200101/189 X-Sequence-Number: 853 It is possible to extract rows in a table using SELECT name FROM table WHERE name >= 'Bergman'. The problem I have is that I get names like "Berg, Paul" with this query, and I don't want that. Is there documentation on how >= and <= works with varchar fields? Does pg count in the "," character or ignore it? And so on... Version is 7.0.1. /Rolf