Funcionaría tambien algo asi como:
update minusculas set a = upper(a) :
--
Alex Alvarado C.
Leonel Nunez wrote:
>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=>
>
>
>
>
>