Help needed with regualr, or regexs expressions. - Mailing list pgsql-general

From Robert Chalmers
Subject Help needed with regualr, or regexs expressions.
Date
Msg-id 001501beae3d$819ada80$1a6001cb@chalmers.com.au
Whole thread Raw
List pgsql-general

Hi,
I trying to return specific codes from the database, and the part of the
code that works when actually in the database is like this;

    => select code from catalog where code ~ '^1[a-zA-Z]';

This works, returning ONLY those codes from the table that contain the
number 1 in the first position, and non others.

However....  when placed in the php3 script, like this, it errors out?  What
am I doing wrong???/

(.... and code ~ '^$category[a-zA-Z]' order by code");


Thanks
Robert


---  http://4qir.quantum-radio.net.au - Where Only The Dedicated Survive!
4QIR Quantum Radio. Bringing you the original sounds of AFVN, with some of
the
original DJ's - back on air - and supporting not only the original Vets, in
comprehensive AFVN Archives, but putting together segments for the fighting
men and
women of todays services all around the world. World Music, for people of
the world.



pgsql-general by date:

Previous
From: lynch@cognitivearts.com (Richard Lynch)
Date:
Subject: Re: Weird: attribute 'input' not found
Next
From: nathan@khmere.com
Date:
Subject: Embedded SQL in 'C' (cursors)