pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCase sensitive
6+ messages / 6 participants
[nested] [flat]
* Case sensitive
@ 2002-07-10 06:44 Luis Felipe Acevedo <luis.felipe@unibase.com.mx>
0 siblings, 0 replies; 6+ messages in thread
From: Luis Felipe Acevedo @ 2002-07-10 06:44 UTC (permalink / raw)
To: pgsql-admin
Hi
I have a problem with the case sensitive, is there any form or procedure
to desabled this?
^ permalink raw reply [nested|flat] 6+ messages in thread
* Case-sensitive
@ 2007-01-25 10:52 Alexander B. <burbello3000@yahoo.com.br>
0 siblings, 3 replies; 6+ messages in thread
From: Alexander B. @ 2007-01-25 10:52 UTC (permalink / raw)
To: pgsql-admin
Hi,
One developer asked me about case-sensitive, if its possible disable
Postgres not consider when using comparative functions.
Eg.:
select * from people
where upper(name) like upper('A%');
Is there any parameter that don't take in account case-sensitive, or any
other way to treat??
Thanks
_______________________________________________________
Yahoo! Mail - Sempre a melhor opção para você!
Experimente já e veja as novidades.
http://br.yahoo.com/mailbeta/tudonovo/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Case-sensitive
@ 2007-01-25 12:05 Thomas Pundt <mlists@rp-online.de>
parent: Alexander B. <burbello3000@yahoo.com.br>
2 siblings, 0 replies; 6+ messages in thread
From: Thomas Pundt @ 2007-01-25 12:05 UTC (permalink / raw)
To: pgsql-admin; +Cc: Alexander B. <burbello3000@yahoo.com.br>
Hi,
On Thursday 25 January 2007 11:52, Alexander B. wrote:
| One developer asked me about case-sensitive, if its possible disable
| Postgres not consider when using comparative functions.
| Eg.:
| select * from people
| where upper(name) like upper('A%');
|
| Is there any parameter that don't take in account case-sensitive, or any
| other way to treat??
name ilike 'a%';
name ~* '^a';
For pattern matching operators you can take a look at
http://www.postgresql.org/docs/8.2/interactive/functions-matching.html
Ciao,
Thomas
--
Thomas Pundt <thomas.pundt@rp-online.de> ---- http://rp-online.de/ ----
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Case-sensitive
@ 2007-01-25 12:44 Shoaib Mir <shoaibmir@gmail.com>
parent: Alexander B. <burbello3000@yahoo.com.br>
2 siblings, 1 reply; 6+ messages in thread
From: Shoaib Mir @ 2007-01-25 12:44 UTC (permalink / raw)
To: Alexander B. <burbello3000@yahoo.com.br>; +Cc: pgsql-admin
'citext' module (http://gborg.postgresql.org/project/citext/projdisplay.php)
might help you with this....
-----------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/25/07, Alexander B. <burbello3000@yahoo.com.br> wrote:
>
> Hi,
>
> One developer asked me about case-sensitive, if its possible disable
> Postgres not consider when using comparative functions.
> Eg.:
> select * from people
> where upper(name) like upper('A%');
>
> Is there any parameter that don't take in account case-sensitive, or any
> other way to treat??
>
> Thanks
>
>
>
>
>
>
> _______________________________________________________
> Yahoo! Mail - Sempre a melhor opção para você!
> Experimente já e veja as novidades.
> http://br.yahoo.com/mailbeta/tudonovo/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Case-sensitive
@ 2007-01-25 15:09 Bruce Momjian <bruce@momjian.us>
parent: Shoaib Mir <shoaibmir@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Bruce Momjian @ 2007-01-25 15:09 UTC (permalink / raw)
To: Shoaib Mir <shoaibmir@gmail.com>; +Cc: Alexander B. <burbello3000@yahoo.com.br>; pgsql-admin
And there is an FAQ about this.
---------------------------------------------------------------------------
Shoaib Mir wrote:
> 'citext' module (http://gborg.postgresql.org/project/citext/projdisplay.php)
> might help you with this....
>
> -----------
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
>
> On 1/25/07, Alexander B. <burbello3000@yahoo.com.br> wrote:
> >
> > Hi,
> >
> > One developer asked me about case-sensitive, if its possible disable
> > Postgres not consider when using comparative functions.
> > Eg.:
> > select * from people
> > where upper(name) like upper('A%');
> >
> > Is there any parameter that don't take in account case-sensitive, or any
> > other way to treat??
> >
> > Thanks
> >
> >
> >
> >
> >
> >
> > _______________________________________________________
> > Yahoo! Mail - Sempre a melhor op??o para voc?!
> > Experimente j? e veja as novidades.
> > http://br.yahoo.com/mailbeta/tudonovo/
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: Don't 'kill -9' the postmaster
> >
--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Case-sensitive
@ 2007-01-25 17:45 Bruno Wolff III <bruno@wolff.to>
parent: Alexander B. <burbello3000@yahoo.com.br>
2 siblings, 0 replies; 6+ messages in thread
From: Bruno Wolff III @ 2007-01-25 17:45 UTC (permalink / raw)
To: Alexander B. <burbello3000@yahoo.com.br>; +Cc: pgsql-admin
On Thu, Jan 25, 2007 at 08:52:28 -0200,
"Alexander B." <burbello3000@yahoo.com.br> wrote:
> Hi,
>
> One developer asked me about case-sensitive, if its possible disable
> Postgres not consider when using comparative functions.
> Eg.:
> select * from people
> where upper(name) like upper('A%');
>
> Is there any parameter that don't take in account case-sensitive, or any
> other way to treat??
You can use ilike, though using upper (on the column, not the pattern) has the
advantage that you can create functional indexes that can be used to speed
things up in some cases. There is also an operator for doing case insensitive
regular expression matching.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2007-01-25 17:45 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-10 06:44 Case sensitive Luis Felipe Acevedo <luis.felipe@unibase.com.mx>
2007-01-25 10:52 Case-sensitive Alexander B. <burbello3000@yahoo.com.br>
2007-01-25 12:05 ` Re: Case-sensitive Thomas Pundt <mlists@rp-online.de>
2007-01-25 12:44 ` Re: Case-sensitive Shoaib Mir <shoaibmir@gmail.com>
2007-01-25 15:09 ` Re: Case-sensitive Bruce Momjian <bruce@momjian.us>
2007-01-25 17:45 ` Re: Case-sensitive Bruno Wolff III <bruno@wolff.to>
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