Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 842409FB811 for ; Mon, 19 Feb 2007 11:22:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 10019-05 for ; Mon, 19 Feb 2007 11:22:05 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtpout16.attiva.biz (smtpout16.attiva.biz [85.37.16.18]) by postgresql.org (Postfix) with ESMTP id 09ED69FB7CA for ; Mon, 19 Feb 2007 11:22:10 -0400 (AST) Received: from FBCMFE02B20.fbc.local ([192.168.31.245]) by smtpout16.attiva.biz with Microsoft SMTPSVC(6.0.3790.1830); Mon, 19 Feb 2007 16:22:01 +0100 Received: from dream ([88.34.161.130]) by FBCMFE02B20.fbc.local with Microsoft SMTPSVC(6.0.3790.1830); Mon, 19 Feb 2007 16:22:01 +0100 Message-ID: <001001c75439$b7749b50$1102a8c0@dream> Reply-To: "Shavonne Marietta Wijesinghe" From: "Shavonne Marietta Wijesinghe" To: Subject: Uppercase and Lowercase Date: Mon, 19 Feb 2007 16:22:06 +0100 Organization: Studio FORM MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000D_01C75442.189BB1E0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3028 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-OriginalArrivalTime: 19 Feb 2007 15:22:01.0148 (UTC) FILETIME=[B3E707C0:01C75439] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.189 tagged_above=0 required=5 tests=AWL, BAYES_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200702/193 X-Sequence-Number: 27527 This is a multi-part message in MIME format. ------=_NextPart_000_000D_01C75442.189BB1E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello In my PostgreSQL database i have records inserted in Uppercase.=20 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_indirizzo = =3D upper(substr(pa_indirizzo, 1, 1)) && lower(substr(pa_indirizzo, 2, = length(pa_indirizzo) - 1)) But it doesn't work. When i run only update registro1 set pa_indirizzo =3D = upper(substr(pa_indirizzo, 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 Anyone got any idea?? Thanks Shavonne Wijesinghe ------=_NextPart_000_000D_01C75442.189BB1E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello

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

For example: VIA SENATO

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

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

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

Anyone got any idea??

Thanks

Shavonne = Wijesinghe

------=_NextPart_000_000D_01C75442.189BB1E0--