sort order with < & > in varchar fields

From: Rolf Johansson <rojo(at)nocrew(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: sort order with < & > in varchar fields
Date: 2001-01-17 13:39:46
Message-ID: 7jhf2yfgbh.fsf@junk.nocrew.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-01-17 15:28:15 Re: sort order with < & > in varchar fields
Previous Message Kovacs Zoltan Sandor 2001-01-17 11:07:24 speed of recursive queries, 7.1