From: | Lan Barnes <lan(at)falleagle(dot)net> |
---|---|
To: | Postgres Newbie <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: SELECT of a glob |
Date: | 2006-04-11 18:01:46 |
Message-ID: | 20060411180146.GA31031@falleagle.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Tue, Apr 11, 2006 at 09:51:03AM -0700, Lan Barnes wrote:
> I'm searching my many SQL books, but this eludes me, and I was sure
> there was a syntax for it. I want to send out a select statement that
> finds every string in a field that is essentially larger than (or
> smaller than) a globbed string.
>
> This "... where version_label >= BLD_1*" would return:
>
> BLD_1.0
> BLD_1.1
> BLD_1.2
> BLD_1.4
>
> But not:
>
>
> BLD_0.9
>
> For some reason the keyword "LIKE" is rattling around in my head, but I
> can't find any support for this. Do I have to do this programatically?
>
Answering my own question -- I found it:
SELECT * FROM table WHERE version_label LIKE 'BLD_1%';
The single quotes were the hold up.
Thanks to anyone about to help me ;-)
--
Lan Barnes lan(at)falleagle(dot)net
Linux Guy, SCM Specialist 858-354-0616
Tcl/Tk Enthusiast
From | Date | Subject | |
---|---|---|---|
Next Message | Alasdair Young | 2006-04-11 18:06:16 | Indexes slower when used in decending vs. ascending order? |
Previous Message | Luis Silva | 2006-04-11 17:12:32 | transaction identifier |