[ic] pgsql - sql query with regular-expression

["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]

Thanks

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


_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users