[ic] pgsql - sql query with regular-expression

Chen Naor chennaor@netvision.net.il
Thu, 1 Feb 2001 01:32:05 +0200


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]

Thanks

Chen Naor
Lilux Systems.
http://www.lilux.co.il
email: chen@lilux.co.il