[dev] Issue with Postgres in SQL.php

Chuck Hagenbuch chuck at horde.org
Mon Jun 23 19:24:59 PDT 2003


Quoting Jeff Seifert <seifert at everybody.org>:

> 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.

Just FYI, I'm going to leave this to one of our postgres-using developers to
take care of...

-chuck

--
Charles Hagenbuch, <chuck at horde.org>
The alligators were there, too, in a bathtub inside the house.


More information about the dev mailing list