[dev] Issue with Postgres in SQL.php

[Jeff Seifert]

In the library file horde/lib/SQL.php, I've run into a problem with the code
under the buildClause function for Postgres.  In particular, it relies on the
'SIMILAR TO' comparison operator.  Unfortunately, this operator (while SQL99
compliant) was only recently introduced in Postgres 7.3; older versions of
Postgres do not support this.  (I'm running 7.2.)

The following patch should allow it to work with Postgres version 7.1 or newer.
I haven't tested it thoroughly, but seems to work for me so far.  If anyone can
figure out a more efficient way to code this for Postgres, more power to them.

-Jeff
--
/* A progammer is a machine for turning coffee into code */
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SQL.php.diff
Type: image/x-3ds
Size: 851 bytes
Desc: not available
Url : http://lists.horde.org/archives/dev/attachments/20030623/45518f28/SQL.php.bin