Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5CGSbE38838 for ; Tue, 12 Jun 2001 12:28:37 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5BKwvE89762 for ; Mon, 11 Jun 2001 16:58:57 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f5BKbmq24797 for pgsql-sql@postgresql.org; Mon, 11 Jun 2001 16:37:48 -0400 (EDT) (envelope-from news) From: "JWR" X-Newsgroups: comp.databases.postgresql.sql Subject: Re: update from another table Date: Mon, 11 Jun 2001 15:37:42 -0500 Organization: Digital Domination Lines: 31 Message-ID: <9g3a6s$o6q$1@news.tht.net> References: <9fq8eq$1cpd$1@news.tht.net> X-Complaints-To: scrappy@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 To: pgsql-sql@postgresql.org X-Archive-Number: 200106/181 X-Sequence-Number: 3411 That doesn't tend to work in any SQL database I've ever used, though I'm told Informix can do something similiar. You need to insert the data into a temp table then delete the rows in the base table, then insert back from the temp table. Yeah it is a pain. John "ivan" wrote in message news:9fq8eq$1cpd$1@news.tht.net... > dear sir, > > i would like to know how can i update a table with columns from another > table and adding a new column with a secuence, > > i have try > > update table > set column = (select column from table2), ......, set column=secuence.. > > is it right????? > > thanks > > ivan > > >