Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D8AA89FB270 for ; Sun, 4 Feb 2007 01:16:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 73680-03-2 for ; Sun, 4 Feb 2007 01:16:26 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.188]) by postgresql.org (Postfix) with ESMTP id 0582F9FB31D for ; Sun, 4 Feb 2007 01:11:43 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so1752121nfb for ; Sat, 03 Feb 2007 21:11:42 -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=UOKLHbvVaN22+W3IYdRgcN3xRtJKdeWJIaICwoHD4qBQAbmXQTkP1DntU7JmCLuGR7+pk2qpDbPozBTkFbeMSOfKEF1WomMaDT9ocDkoLY17+YMBkHppm1xQgwDXheVm6to8BmZBvf0x7xhL5BzNwQhDwAvIGcZT+hu8GrICOnA= Received: by 10.78.122.11 with SMTP id u11mr156247huc.1170565902537; Sat, 03 Feb 2007 21:11:42 -0800 (PST) Received: by 10.78.139.16 with HTTP; Sat, 3 Feb 2007 21:11:42 -0800 (PST) Message-ID: Date: Sun, 4 Feb 2007 00:11:42 -0500 From: "Jaime Casanova" To: "jeferson alvarez" Subject: Re: identity es postgresql Cc: pgsql-es-ayuda@postgresql.org In-Reply-To: <45D496E7.6040502@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> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/43 X-Sequence-Number: 24073 On 2/15/07, jeferson alvarez wrote: > 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 > no entiendo... que es lo que quieres que haga la funcion identity? -- 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