Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 8B93D9FB2A6 for ; Mon, 5 Feb 2007 20:45:45 -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 96938-03 for ; Mon, 5 Feb 2007 20:45:36 -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.172]) by postgresql.org (Postfix) with ESMTP id 352C69FA371 for ; Mon, 5 Feb 2007 20:45:41 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so1295018ugf for ; Mon, 05 Feb 2007 16:45:39 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=OxALq+9MLSNRgOShnxa6ss6WKnKTAwI8scWfmC2FPOxdBheqxBclhNEdEB1SdiCzdFw1F0XRx/dXEcV1/xeflRqjqQpiYWSFfizEMBvgjaFEjfNsAKCA9d1CuZW3iFRtq71IOcdHzSr2n5o7QvMkMW4VL0M5f42fXOmYR+YE7U4= Received: by 10.78.122.11 with SMTP id u11mr567364huc.1170722738979; Mon, 05 Feb 2007 16:45:38 -0800 (PST) Received: by 10.78.139.16 with HTTP; Mon, 5 Feb 2007 16:45:38 -0800 (PST) Message-ID: Date: Mon, 5 Feb 2007 19:45:38 -0500 From: "Jaime Casanova" To: "jeferson alvarez" Subject: Re: identity es postgresql Cc: "=?ISO-8859-1?Q?Postgres_Espa=F1ol?=" In-Reply-To: <45C72179.9030503@renova.com.pe> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <45D496E7.6040502@renova.com.pe> <45C72179.9030503@renova.com.pe> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/73 X-Sequence-Number: 24103 Siempre con copia a la lista por favor On 2/5/07, jeferson alvarez wrote: > identity codigo > 1 xxxxx > 2 hhhhh > 3 yyuyyy > 4 uuuuuu > 5 gggggg > create temp sequence s1; select nextval('s1'), CODIGO from articulo; -- Atentamente, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning." Richard Cook