new calculated column - Mailing list pgsql-sql

From andres javier garcia garcia
Subject new calculated column
Date
Msg-id 200209051652.g85Gqki20106@natura.cebas.csic.es
Whole thread Raw
List pgsql-sql
Hi;

I've got a table with two fields and about 3000 rows, the second one is a 
character field, what can have about twenty different values; of course these 
values are repeated a lot of times in the table. I need to create a new 
column of type integer, whose value depens on the character fields. The 
values of the new column are not important, the important thing is who can I 
create this column and assign a different integer to a different char value 
in the other column.
Thanks
--------------
Javier


pgsql-sql by date:

Previous
From: Viacheslav N Tararin
Date:
Subject: Re: the best way to get the topest 3 record in every group
Next
From: "Linn Kubler"
Date:
Subject: Character translation?