pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedCase in-sensitive
4+ messages / 4 participants
[nested] [flat]
* Case in-sensitive
@ 2002-07-23 14:35 Carmen Wai <wai_carmen@hotmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: Carmen Wai @ 2002-07-23 14:35 UTC (permalink / raw)
To: pgsql-sql; pgsql-general@postgresql.org
Hello:
Can I config the Postgresql so that it can match case in-sensitive pattern
automatically? i.e. I don't need to explicit convert the pattern to lower
case like this: .....WHERE lower(textfield) LIKE lower(pattern)
Thanks a lot!
Carmen
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Case in-sensitive
@ 2002-07-23 14:46 Andrew Sullivan <andrew@libertyrms.info>
parent: Carmen Wai <wai_carmen@hotmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Andrew Sullivan @ 2002-07-23 14:46 UTC (permalink / raw)
To: pgsql-general@postgresql.org
On Tue, Jul 23, 2002 at 02:35:40PM +0000, Carmen Wai wrote:
> Hello:
>
> Can I config the Postgresql so that it can match case in-sensitive pattern
> automatically? i.e. I don't need to explicit convert the pattern to lower
> case like this: .....WHERE lower(textfield) LIKE lower(pattern)
No. But you can use ILIKE, which is a case-insensitive LIKE.
A
--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M6K 3E3
+1 416 646 3304 x110
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] Case in-sensitive
@ 2002-07-25 02:21 Christopher Kings-Lynne <chriskl@familyhealth.com.au>
parent: Carmen Wai <wai_carmen@hotmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Christopher Kings-Lynne @ 2002-07-25 02:21 UTC (permalink / raw)
To: Carmen Wai <wai_carmen@hotmail.com>; pgsql-sql; pgsql-general@postgresql.org
> Can I config the Postgresql so that it can match case
> in-sensitive pattern
> automatically? i.e. I don't need to explicit convert the pattern to lower
> case like this: .....WHERE lower(textfield) LIKE lower(pattern)
All you need to do is this:
......WHERE textfield ILIKE pattern
Chris
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] Case in-sensitive
@ 2002-07-25 02:27 Josh Berkus <josh@agliodbs.com>
parent: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
0 siblings, 0 replies; 4+ messages in thread
From: Josh Berkus @ 2002-07-25 02:27 UTC (permalink / raw)
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>; Carmen Wai <wai_carmen@hotmail.com>; pgsql-sql; pgsql-general@postgresql.org
Chris,
> > Can I config the Postgresql so that it can match case
> > in-sensitive pattern
> > automatically? i.e. I don't need to explicit convert the pattern to lower
> > case like this: .....WHERE lower(textfield) LIKE lower(pattern)
>
> All you need to do is this:
>
> ......WHERE textfield ILIKE pattern
Though, keep in mind, lower(textfield) can be indexed, but ILIKE textfield
cannot.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2002-07-25 02:27 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-23 14:35 Case in-sensitive Carmen Wai <wai_carmen@hotmail.com>
2002-07-23 14:46 ` Andrew Sullivan <andrew@libertyrms.info>
2002-07-25 02:21 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2002-07-25 02:27 ` Josh Berkus <josh@agliodbs.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox