pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Case 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