PostgreSQL has an upper() function and it works just fine in a Witango custom column.
PostgreSQL has many built-in functions:
http://www.postgresql.org/idocs/index.php?functions.html
It is also extensible so you can create your own functions, data types and operators
in several supported languages: SQL, PL/PgSQL (like Oracle's PL/SQL), TCL, Perl, C,
etc.
MySQL CHAR and VARCHAR columns are case insensitive by default, but you can also
define those columns to be case sensitive.
I've been learning a lot about PostgreSQL lately and think it is great, especially if
you have a busy site that uses a complex database structure. Feel free to send me
questions about it.
- Jeff
>No a problem,
>
>I had to chuckle when after I posted my reply, Dave's came in and I
>realized we had said almost the exact same solution :-)
>
>I am curious (Because I am looking at MySQL and PostgreSQL) what was
>your solution? Is there a upper() function in PostgreSQL?
>
>Ben Johansen - http://www.pcforge.com
>Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm
>Latest downloads & List Archives @ http://www.witango.ws
>
>
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:owner-witango-talk@;witango.com] On Behalf Of Jeffrey Bohmer
>Sent: Thursday, October 17, 2002 10:39 AM
>To: Multiple recipients of list witango-talk
>Subject: RE: Witango-Talk: Case insensitive search in search action
>
>
>Thanks Dave and Ben,
>
>I didn't know about the custom column in search actions.
>
>- Jeff
>
>
>>You could convert both the column reference and postarg to upper case
>or
>>lower case.
>>Specify a custom column reference in your search criteria and enter
>>upper(colName) = <@upper <@arg argName>>.
>>This assumes of course that PostgreSQL supports the upper() function.
>>
>>Dave Shelley
>>
>>-----Original Message-----
>>From: [EMAIL PROTECTED]
>>[mailto:owner-witango-talk@;witango.com]On Behalf Of Jeffrey Bohmer
>>Sent: Wednesday, October 16, 2002 10:00 PM
>>To: Multiple recipients of list witango-talk
>>Subject: Witango-Talk: Case insensitive search in search action
>>
>>
>>
>>Is there a way to create a case insensitive search in a search action
>>instead of using a DirectDBMS action?
>>
>>I want the user input to match regardless of case, so that 'blue' would
>>match 'blue' and 'Blue' and 'BLUE', etc. I'm using PostgreSQL, which
>is
>>case sensitive and cannot really be made case insensitive. I have a
>bunch
>>of search actions converted from FMP, which is case insensitive, and
>would
>>like to avoid re-creating them as DirectDBMS actions.
>>
>>Witango 5, iODBC, Mac OS X.
>>
>>TIA,
>>- Jeff
>>--
>>
>>Jeff Bohmer
>>VisionLink, Inc.
>>_________________________________
>>303.402.0170
>>www.visionlink.org
>>_________________________________
>>People. Tools. Change. Community.
>>_______________________________________________________________________
>_
>>TO UNSUBSCRIBE: send a plain text/US ASCII email to
>[EMAIL PROTECTED]
>> with unsubscribe witango-talk in the message body
>>
>>_______________________________________________________________________
>_
>>TO UNSUBSCRIBE: send a plain text/US ASCII email to
>[EMAIL PROTECTED]
>> with unsubscribe witango-talk in the message body
>
>--
>
>Jeff Bohmer
>VisionLink, Inc.
>_________________________________
>303.402.0170
>www.visionlink.org
>_________________________________
>People. Tools. Change. Community.
>________________________________________________________________________
>TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
> with unsubscribe witango-talk in the message body
>
>________________________________________________________________________
>TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
> with unsubscribe witango-talk in the message body
--
Jeff Bohmer
VisionLink, Inc.
_________________________________
303.402.0170
www.visionlink.org
_________________________________
People. Tools. Change. Community.
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
