Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 55D784764F9 for ; Mon, 9 Sep 2002 10:06:53 -0400 (EDT) Received: from dekasoft.com.ua (unknown [193.201.199.5]) by postgresql.org (Postfix) with ESMTP id 5D4D947580B for ; Mon, 9 Sep 2002 10:03:57 -0400 (EDT) Received: from dekasoft.com.ua (unknown [192.168.1.9]) by dekasoft.com.ua (Postfix) with ESMTP id D9DC6CF64; Mon, 9 Sep 2002 17:03:55 +0300 (EEST) Message-ID: <3D7CA9AB.8070903@dekasoft.com.ua> Date: Mon, 09 Sep 2002 17:01:15 +0300 From: Viacheslav N Tararin User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; ru-RU; rv:1.0.0) Gecko/20020526 X-Accept-Language: uk, ru, en-us MIME-Version: 1.0 To: andres javier garcia garcia , pgsql-sql@postgresql.org Subject: Re: new calculated column References: <200209051652.g85Gqki20106@natura.cebas.csic.es> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/46 X-Sequence-Number: 9323 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 > > > >