Re: [Phpgroupware-developers] Follow Up: Questions from New User/Developer

[Peter]

Hello Chris,
Thank you for the PostgreSQL tutorial. I like the answer.

Ilike is both case insensitive and interprets case according to location so 
caseless languages will be interpreted without 
case. Hopefully the SQL standard will gain an equivalent feature.

Does phpgw support/insert the PostgreSQL location?

Peter


2/22/02 11:22:00 AM, "Chris Weiss" <address@hidden> wrote:

>Or even better, use ILIKE instead of LIKE
>http://www.postgresql.org/idocs/index.php?functions-matching.html
>
>(not bad for a non-pg guy)
>
>
>Ashleigh Gordon (address@hidden) wrote*:
>>
>>Thanks for quick help. From what I've found, it looks like postgresql
>>doesn't have a global parameter to have case insensitive searches. So
>>I've made a quick hack in the query string in
>>class.contacts_sql.inc.php, to make it case insensitive. Here it is:
>>
>>        /* Replace $sql .= " $f LIKE '%$query%' OR "; with */
>>        $sql .= " $f LIKE '%$query%' OR $f LIKE lower('%$query%') OR $f
>>LIKE upper('%$query%') OR $f LIKE initcap('$query%') OR ";
>>
>>This does makethe query rather large however, but it will do for now
>>
>>I've also attached my update and insert triggers. In order to enable
>>triggers in postgresql, at the command prompt, type "createlang plpgsql
>>phpgroupware". I think that I should probably document this and some
>>other things to make it a bit easier for others. Who is currently
>>co-ordinating/working on the documentation? I think that I could
>>probably write the documentation for the addressbook now if you would like.
>>
>>Ashleigh Gordon
>>
>>
>
>
>_______________________________________________
>Phpgroupware-developers mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>