From: | Leonel Nunez <postgres(at)enelserver(dot)com> |
---|---|
To: | Emilio Capolupo <ecapolup(at)ta(dot)telecom(dot)com(dot)ar> |
Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Re: Pasar campos texto a mayusculas en forma |
Date: | 2004-08-05 14:13:03 |
Message-ID: | 1091715182.3003.0.camel@debian.enelserver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
On Thu, 2004-08-05 at 07:57, Emilio Capolupo wrote:
> Hola:
>
> Necesito normalizar una tabla con campos texto que se decidio esten
> todos completamente en mayusculas.
>
> Existe alguna forma de hacerlo rapida y limpiamente?
>
> Gracias.
>
> Emilio
>
leonel=> create table minusculas ( a varchar );
CREATE TABLE
leonel=> insert into minusculas values ( 'asdfasdasdasda');
INSERT 17871 1
leonel=> insert into minusculas values ( 'sf sdf sdf sdfsd fsdf');
INSERT 17872 1
leonel=> create table mayusculas ( a varchar );
CREATE TABLE
leonel=> insert into maysculas ( select upper ( a ) from minusculas );
ERROR: relation "maysculas" does not exist
leonel=> insert into mayusculas ( select upper ( a ) from minusculas );
INSERT 0 2
leonel=> select * from mayusculas;
a
-----------------------
ASDFASDASDASDA
SF SDF SDF SDFSD FSDF
(2 rows)
leonel=>
--
,''`. Leonel Nunez
: :' : http://enelserver.com
`. `' DEBIAN GNU/LINUX
`- A REAL FREE OS
From | Date | Subject | |
---|---|---|---|
Next Message | Roberto César Najera Núñez | 2004-08-05 18:30:38 | Fw: PGDATA2 |
Previous Message | Emilio Capolupo | 2004-08-05 13:57:00 | Pasar campos texto a mayusculas en forma masiva |