Re: new calculated column

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(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly
>
>
>
>