[ic] pgsql - sql query with regular-expression
Wed, 31 Jan 2001 21:08:04 -0500
Quoting Chen Naor (firstname.lastname@example.org):
> using postgresql 7.0.3.
> I'm trying to use regular-expression in a sql queries - is it possible in
> minivend/interchange? (it works in pgsql)
> This is what I'm trying to do, but I fail:
> SELECT COUNT(*) FROM products
> WHERE category = 'BOGU' and countries like ~
> '[^A-Z]*(AT)[^A-Z]*' |
> [sql-param count]
Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <email@example.com>
I have a cop friend who thinks he ought be able to give a new ticket;
"too dumb for conditions".