Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4DB599FB704 for ; Mon, 19 Feb 2007 11:26:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 64121-03 for ; Mon, 19 Feb 2007 11:26:04 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3]) by postgresql.org (Postfix) with ESMTP id DFBD59FB6A0 for ; Mon, 19 Feb 2007 11:26:03 -0400 (AST) Received: from webaccess.indicator.be ([10.100.1.7]) by interscan.indicator.com with InterScan Message Security Suite; Mon, 19 Feb 2007 16:13:51 +0100 Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise; Mon, 19 Feb 2007 16:26:01 +0100 Message-Id: <45D9CF8C.A3DD.0030.0@indicator.be> X-Mailer: Novell GroupWise Internet Agent 7.0.1 Date: Mon, 19 Feb 2007 16:25:48 +0100 From: "Bart Degryse" To: Subject: Re: Uppercase and Lowercase References: <001001c75439$b7749b50$1102a8c0@dream> In-Reply-To: <001001c75439$b7749b50$1102a8c0@dream> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__Part597DC86C.0__=" X-imss-version: 2.046 X-imss-result: Passed X-imss-approveListMatch: *@indicator.be X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.272 tagged_above=0 required=5 tests=BAYES_50, FORGED_RCVD_HELO, HTML_50_60, HTML_MESSAGE, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200702/194 X-Sequence-Number: 27528 --=__Part597DC86C.0__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Replace && by || >>> "Shavonne Marietta Wijesinghe" = 2007-02-19 16:22 >>> Hello =20 In my PostgreSQL database i have records inserted in Uppercase.=20 For example: VIA SENATO =20 What i want is to change them to "Via Senato". Ofcourse i'm looking for a = automatico way. I wrote this code update registro1 set pa_indirizzo =3D = upper(substr(pa_indirizzo, 1, 1)) && lower(substr(pa_indirizzo, 2, = length(pa_indirizzo) - 1)) But it doesn't work. =20 When i run only update registro1 set pa_indirizzo =3D upper(substr(pa_indir= izzo, 1, 1)) It gets me the first letter and when i run update registro1 set pa_indirizzo =3D lower(substr(pa_indirizzo, 2, = length(pa_indirizzo) - 1)) I get from the second letter to the last. But = when i join them them don't work.. =20 =20 Anyone got any idea?? =20 Thanks =20 Shavonne Wijesinghe --=__Part597DC86C.0__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Description: HTML Replace && = by ||

>>> "Shavonne Marietta Wijesinghe" <shavonne.marie= tta@studioform.it> 2007-02-19 16:22 >>>

Hello

In my PostgreSQL database i have records = inserted in Uppercase.

For example: VIA SENATO

What i want is to change them to "Via = Senato". Ofcourse i'm looking for a automatico way. I wrote this code = update registro1 set pa_indirizz= o =3D upper(substr(pa_indirizzo, 1, 1)) && lower(substr(pa_indirizz= o, 2, length(pa_indirizzo) - 1)) But it = doesn't work.

When i run only update registro1 set pa_indirizzo =3D upper(substr(pa_indi= rizzo, 1, 1)) It gets me the first = letter and when i run

update registro1 set pa_indirizzo = =3D lower(substr(pa_indirizzo, 2, length(pa_indirizzo) - 1)) I get from the second letter to the last. But = when i join them them don't work..

Anyone got any idea??

Thanks

Shavonne Wijesinghe

--=__Part597DC86C.0__=--