Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id A9F4E9FA29D for ; Sat, 3 Feb 2007 13:23:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 39745-03 for ; Sat, 3 Feb 2007 13:23:35 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 9FBC29FA18C for ; Sat, 3 Feb 2007 13:23:35 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mailserver.renova.com.pe (mailserver.renova.com.pe [200.4.223.33]) by svr4.postgresql.org (Postfix) with ESMTP id D46C15AFC9D for ; Sat, 3 Feb 2007 17:23:34 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mailserver.renova.com.pe (Postfix) with ESMTP id 6BB471340C5 for ; Sat, 3 Feb 2007 12:22:29 -0500 (PET) Received: from mailserver.renova.com.pe ([127.0.0.1]) by localhost (mailserver [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25862-10 for ; Sat, 3 Feb 2007 12:22:29 -0500 (PET) Received: from [192.168.1.178] (unknown [192.168.1.178]) by mailserver.renova.com.pe (Postfix) with ESMTP id 30F671340C4 for ; Sat, 3 Feb 2007 12:22:29 -0500 (PET) Message-ID: <45D496E7.6040502@renova.com.pe> Date: Thu, 15 Feb 2007 12:22:47 -0500 From: jeferson alvarez User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: pgsql-es-ayuda@postgresql.org Subject: identity es postgresql Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at renova.com.pe X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.72 tagged_above=0 required=5 tests=AWL, BAYES_99, DATE_IN_FUTURE_96_XX X-Spam-Level: *** X-Archive-Number: 200702/42 X-Sequence-Number: 24072 Hola amigos esta es la idea de lo que quiero hacer select identity(int4,1, 1), CODIGO from articulo quiero sacar algo como eso hacer un listado de codigos x ej y que me aparesca la lista numerada gracias