Received: from desmpop1.desm.uswest.net (desmpop1.desm.uswest.net [207.108.32.1]) by hub.org (8.9.1/8.9.1) with SMTP id XAA27294 for ; Sat, 9 Jan 1999 23:09:03 -0500 (EST) (envelope-from tim@dmcity.net) Received: (qmail 23819 invoked by alias); 10 Jan 1999 04:09:00 -0000 Delivered-To: fixup-pgsql-sql@hub.org@fixme Received: (qmail 23805 invoked by uid 0); 10 Jan 1999 04:08:59 -0000 Received: from bdsl97.desm.uswest.net (HELO timnt) (207.108.36.97) by desmpop1.desm.uswest.net with SMTP; 10 Jan 1999 04:08:59 -0000 Message-ID: <005501be3c4e$14b897b0$61246ccf@timnt.desm.uswest.net> Reply-To: "Tim Perdue, The Des Moines City.net" From: "Tim Perdue, The Des Moines City.net" To: "Bruce Momjian" , Subject: Re: [SQL] SELECT... BETWEEN 'P' and 'Z' Date: Sat, 9 Jan 1999 22:02:46 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 What I did was make the Z lowercase, since lowercase Z would be a bigger number in the ASCII character set. So now I'm doing "where x between 'P' and 'z';" and I get everything that I want. --Tim -----Original Message----- From: Bruce Momjian To: tim@dmcity.net Cc: pgsql-sql@hub.org Date: Saturday, January 09, 1999 7:48 PM Subject: Re: [SQL] SELECT... BETWEEN 'P' and 'Z' > >Tried it here: > > test=> create table test5(x char(50)); > CREATE > test=> insert into test5 values ('P'); > INSERT 18665 1 > test=> insert into test5 values ('Z'); > INSERT 18666 1 > test=> insert into test5 values ('S'); > INSERT 18667 1 > test=> select * from test5 where x between 'P' and 'Z'; > x > -------------------------------------------------- > P > Z > S > (3 rows) > >This is the 6.5 development tree, but should be the same on 6.4.*. > >-- > Bruce Momjian | http://www.op.net/~candle > maillist@candle.pha.pa.us | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026