new calculated column - Mailing list pgsql-sql

From andres javier garcia garcia
Subject new calculated column
Date
Msg-id 200209051657.g85Gvei20144@natura.cebas.csic.es
Whole thread Raw
Responses Re: new calculated column  (<mallah@trade-india.com>)
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: "Josh Berkus"
Date:
Subject: Re: fumbling for join syntax
Next
From: "Ligia Pimentel"
Date:
Subject: Re: Update help