[ic] pgsql - sql query with regular-expression

[Mike Heins]

Quoting Chen Naor (chennaor@netvision.net.il):
> Hi,
> 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:
>  [query
>                         list=1
>                         st=db
>                         sql=|
>                         SELECT  COUNT(*) FROM products
>                         WHERE category = 'BOGU' and countries like ~
> '[^A-Z]*(AT)[^A-Z]*'                         |
>                         ]
> 
>                         [sql-param count]
> 
>     [/query]
> 

    [sql-pos 0]

-- 
Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH  45056
phone +1.513.523.7621 fax 7501 <heins@akopia.com>

I have a cop friend who thinks he ought be able to give a new ticket;
"too dumb for conditions".