Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 86AF09FB3F2 for ; Sat, 24 Feb 2007 20:06:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 01458-09 for ; Sat, 24 Feb 2007 20:06:37 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.173]) by postgresql.org (Postfix) with ESMTP id A213B9FB3B1 for ; Sat, 24 Feb 2007 20:06:47 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so510926ugf for ; Sat, 24 Feb 2007 16:06:46 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=g6pPriD6qiPX+8RojpObmLeFmGl407sYvxE8cH0Ia0qWxL5RGLnSwCfNCu2IZXcURl7xfagU25IBkGLsILS7ESqkvi7yEtuyfJDQIXVc27puvgMYwXaGV3odPZGnpqiVO75kW5loVvsJejIuzJZgn2GIXwsoprB4e5dRvd5YEs0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=qJRjNI687LcdHeRtUs5/lwXixow4CEkN72Iq5LkRrIY731PxDyuutzTzK4EhhYALvZT5Ty2mV6trZvJez/K6Iawp4DHjL/H6QTRuGQEuNrGak8zFP+rzBxVFhLJ20r+oIU3t3Vxi0LWAWfR5nPiZuSFTj/gQ/lDnqsueh0glJWs= Received: by 10.67.101.10 with SMTP id d10mr4180040ugm.1172362006259; Sat, 24 Feb 2007 16:06:46 -0800 (PST) Received: by 10.67.94.13 with HTTP; Sat, 24 Feb 2007 16:06:46 -0800 (PST) Message-ID: <55c095e90702241606x4d15b7a9v5b084e575ef23140@mail.gmail.com> Date: Sat, 24 Feb 2007 21:06:46 -0300 From: "Ezequias Rodrigues da Rocha" To: pgsql-sql@postgresql.org Subject: Insert based in a select MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/249 X-Sequence-Number: 27583 Hi list, Could someone help me with this problem I have a table like this Master table id number 10 9898398398 20 9938378390 30 9873636736 and I want to make an insert into a table with this structure: Secondary table id(sequence), master_id 1 10 2 20 3 30 It is possible to make this insert based in all records of my master table ? Any help would be very welcomed. Best Regards Ezequias