Обсуждение: Selecting Varchar range.

Dear PostgreSQL people,

    I didn't find this in the archives or the idocs, so...

    How does one select a varchar range? The meaning of my question is
best illustrated by the following completely hypothetical and totally
imaginary situation:
    Let's say I have a table of musical artists:

CREATE TABLE Artists (
    Id SERIAL PRIMARY KEY,
    Name VARCHAR(100)
);

    And I want to eventually display only the artists from 'Aa' to 'Am'.
Naturally doing a select where Name like 'A%' will not return me what I
want.
    Any ides on how to do this? [Will "SELECT Name FROM Artists WHERE
Name > 'Aa%' AND Name < 'Am%';" work?]

    Bonus question: How do I select artists whose names start with a
number?

    I'd appreciate any help. Thanks! :)

Sincerely,

    Daryl.

On Mon, 12 Aug 2002, Daryl Beattie wrote:

> Dear PostgreSQL people,
>
>     I didn't find this in the archives or the idocs, so...
>
>     How does one select a varchar range? The meaning of my question is
> best illustrated by the following completely hypothetical and totally
> imaginary situation:
>     Let's say I have a table of musical artists:
>
> CREATE TABLE Artists (
>     Id SERIAL PRIMARY KEY,
>     Name VARCHAR(100)
> );
>
>     And I want to eventually display only the artists from 'Aa' to 'Am'.
> Naturally doing a select where Name like 'A%' will not return me what I
> want.
>     Any ides on how to do this? [Will "SELECT Name FROM Artists WHERE
> Name > 'Aa%' AND Name < 'Am%';" work?]
>
>     Bonus question: How do I select artists whose names start with a
> number?

Think REGEX.    A[a-m]%   [0-9]%

If any of your artists are indies, send them to www.unknown-artists.com

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
      http://www.camping-usa.com      http://www.cloudninegifts.com
   http://www.meanstreamradio.com       http://www.unknown-artists.com
==========================================================================