Re: new calculated column - Mailing list pgsql-sql

From Viacheslav N Tararin
Subject Re: new calculated column
Date
Msg-id 3D7CA9AB.8070903@dekasoft.com.ua
Whole thread Raw
In response to new calculated column  (andres javier garcia garcia <andresjavier.garcia@wanadoo.es>)
List pgsql-sql
For implicit modification you can use a trigger on the table. If you 
wan't store this data, you can use view.

andres javier garcia garcia ?????:

>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
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
>
>
>  
>





pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Efficiency Question
Next
From: Viacheslav N Tararin
Date:
Subject: Re: Cross tables Like%