Hi John,
Because Pg does not support the REGEXP keyword, will be great if you can add
in QueryBuilder, specially for Pg, the ~, ~* and SIMILAR TO comparison
operators . It is only a small addition :)
(patch for QueryBuilder v.0.75):
===============================
--- site_perl/Rose/DB/Object/QueryBuilder.pm 2006-08-30
21:04:28.000000000 +0300
+++ lib/Rose/DB/Object/QueryBuilder.pm 2006-09-11 11:57:37.000000000 +0300
@@ -17,6 +17,9 @@
my %OP_MAP =
(
+ similar => 'SIMILAR TO',
+ match => '~',
+ imatch => '~*',
regex => 'REGEXP',
regexp => 'REGEXP',
like => 'LIKE',
@@ -1052,6 +1055,9 @@
OP SQL operator
------------- ------------
+ similar SIMILAR TO
+ match ~
+ imatch ~*
regex, regexp REGEXP
like LIKE
ilike ILIKE
===============================
Thank you,
Lucian Dragus
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
