Skip site navigation (1) Skip section navigation (2)

Re: Pasar campos texto a mayusculas en forma

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 (view raw or flat)
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



In response to

Responses

pgsql-es-ayuda by date

Next:From: Roberto César Najera NúñezDate: 2004-08-05 18:30:38
Subject: Fw: PGDATA2
Previous:From: Emilio CapolupoDate: 2004-08-05 13:57:00
Subject: Pasar campos texto a mayusculas en forma masiva

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group