From: | "tjk(at)tksoft(dot)com" <tjk(at)tksoft(dot)com> |
---|---|
To: | mark(at)zserve(dot)com (Mark) |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Case Insensitive Queries |
Date: | 2001-05-29 15:23:52 |
Message-ID: | 200105291523.IAA23977@smtp3.tksoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
select * from account where lower(username) = lower('test');
Troy
>
> Is it possible to execute a query using a where clause that allows case
> insensitive comparison between a field and text.
>
> For example:
>
> select * from account where username = 'test'
>
> where username could be 'Test', which would be a match. As is, this
> compare is case sensitive.
>
> grep'd the source, but stricmp is only used for keywords and not actual
> column data.
>
> Any help would be greatly appreciated.
>
> Thanks,
>
> Mark
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mark | 2001-05-29 16:21:15 | Re: Case Insensitive Queries |
Previous Message | Mark | 2001-05-29 15:11:23 | Case Insensitive Queries |