LIKE missing in gadfly

Gordon McMillan gmcm at hypernet.com
Wed Oct 10 14:47:11 CEST 2001


Christophe Delarue wrote:

> I make through a gfclient/gfserve a query resulting of a wilde result.
> 
> Right now, I reduce this result on the client side by using a regexp
> on a
> special field.  How could this be done on the server side ?

[snip]

> I'd like something  :
> 
> SELECT name FROM fellows WHERE name LIKE
> NAME.match(re.compile("[A-Z]{2}'[A-Za-z]+"))

Even if gadfly implemented LIKE, it wouldn't suit your needs,
because "... name LIKE 'AB' ..." is just shorhand for
(roughly) "... name >= 'AB' and name < 'AC' ... ".

- Gordon



More information about the Python-list mailing list