From: Viacheslav N Tararin <taras@dekasoft.com.ua>
To: andres javier garcia garcia <andresjavier.garcia@wanadoo.es>
To: pgsql-sql@postgresql.org
Subject: Re: new calculated column
Date: Mon, 09 Sep 2002 17:01:15 +0300
Message-ID: <3D7CA9AB.8070903@dekasoft.com.ua> (raw)
References: <200209051652.g85Gqki20106@natura.cebas.csic.es>
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
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: taras@dekasoft.com.ua, andresjavier.garcia@wanadoo.es
Subject: Re: new calculated column
In-Reply-To: <3D7CA9AB.8070903@dekasoft.com.ua>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox