From: | Digital Wokan <wokan(at)home(dot)com> |
---|---|
To: | PostgreSQL General List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Case sensitivity |
Date: | 2001-08-14 04:25:58 |
Message-ID: | 3B78A856.2118BC61@home.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Very good book. I have the .pdf file of it from before they took it off
the site.
John Clark Naldoza y Lopez wrote:
>
> Hello Scott,
>
> PostgreSQL also supports regular expressions, _VERY_ useful..;-)
>
> ~* regular expression, case-insensitive..;-)
>
> Try to get a copy of Bruce's book
>
> Introduction and Concepts
> by Bruce Momjian
>
> A sample from the book:
> SELECT * FROM friend WHERE firstname ~* '[bc]'
>
> read it online, or just read the docs online...;-)
>
> http://techdocs.postgresql.org
>
> Cheers,
>
> John Clark
>
> p.s. don't change PostgreSQL, change your SQL statements...;-)
>
> Scott Gilbert wrote:
> >
> > We intend to move from M$ Access to PostgreSQL, however, much of our legacy
> > code operates under the assumption that string or text comparisons are case
> > insensitive whereas postgres is case sensitive. This issue extends to SQL
> > Select statements as well as straight comparison (i.e. in addition to the <,
> > > and = operators, the WHERE and IN clauses in SQL statements are also
> > issues) so we can't simply modify the function attached to the comparison
> > operators. Is there some means of modifying the behaviour of PostgreSQL so
> > that it is case insensitive?
>
> --
> /) John Clark Naldoza y Lopez (\
> / ) Software Design Engineer III ( \
> _( (_ _ Web-Application Development _) )_
> (((\ \> /_> Cable Modem Network Management System <_\ </ /)))
> (\\\\ \_/ / NEC Telecom Software Phils., Inc. \ \_/ ////)
> \ / \ /
> \ _/ phone: (+63 32) 233-9142 loc. 3113 \_ /
> / / cellphone: (+63 919) 399-4742 \ \
> / / email: njclark(at)ntsp(dot)nec(dot)co(dot)jp \ \
>
> "Intelligence is the ability to avoid doing work, yet getting the work
> done"
> --Linus Torvalds
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Gilbert | 2001-08-14 06:09:47 | Case sensitivity |
Previous Message | Kevin J. Drewiske | 2001-08-14 04:08:38 | RE: delete columns from table! |