Postgres Pro
Downloads
Home   >   mailing lists

SELECT of a glob - Mailing list pgsql-novice

From Lan Barnes
Subject SELECT of a glob
Date
Msg-id 20060411165102.GA30434@falleagle.net
Whole thread Raw
Responses Re: SELECT of a glob  (Lan Barnes <lan@falleagle.net>)
List pgsql-novice
Tree view 
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@falleagle.net
Linux Guy, SCM Specialist     858-354-0616
Tcl/Tk Enthusiast

pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: advice on setting up schema sought
Next
From: "Luis Silva"
Date:
Subject: transaction identifier