Postgres Pro
Downloads
Home   >   mailing lists

sort order with < & > in varchar fields - Mailing list pgsql-sql

From Rolf Johansson
Subject sort order with < & > in varchar fields
Date
Msg-id 7jhf2yfgbh.fsf@junk.nocrew.org
Whole thread Raw
Responses Re: sort order with < & > in varchar fields  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Kovacs Zoltan Sandor
Date:
Subject: speed of recursive queries, 7.1
Next
From: Tom Lane
Date:
Subject: Re: sort order with < & > in varchar fields