[dev] Issue with Postgres in SQL.php

Marcus I. Ryan marcus at horde.org
Tue Jul 15 21:17:56 PDT 2003


Committed with a comment as to why it was changed.

--
Marcus I. Ryan, marcus at horde.org
-----------------------------------------------------------------------
 "Love is a snowmobile racing across the tundra and then suddenly it
 flips over, pinning you underneath.  At night, the ice weasels come."
                 -- Matt Groening
-----------------------------------------------------------------------


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.
>
> -Jeff
> --
> /* A progammer is a machine for turning coffee into code */




More information about the dev mailing list