SELECT of a glob

From: Lan Barnes <lan(at)falleagle(dot)net>
To: Postgres Newbie <pgsql-novice(at)postgresql(dot)org>
Subject: SELECT of a glob
Date: 2006-04-11 16:51:03
Message-ID: 20060411165102.GA30434@falleagle.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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?

--
Lan Barnes lan(at)falleagle(dot)net
Linux Guy, SCM Specialist 858-354-0616
Tcl/Tk Enthusiast

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Luis Silva 2006-04-11 17:12:32 transaction identifier
Previous Message Bruno Wolff III 2006-04-11 16:42:45 Re: advice on setting up schema sought