Re: identity es postgresql

From: "Jaime Casanova" <systemguards(at)gmail(dot)com>
To: "jeferson alvarez" <jalvarez(at)renova(dot)com(dot)pe>
Cc: Postgres Español <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Re: identity es postgresql
Date: 2007-02-06 00:45:38
Message-ID: c2d9e70e0702051645x1731527bhb66b0c107bb94df5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-es-ayuda

Siempre con copia a la lista por favor

On 2/5/07, jeferson alvarez <jalvarez(at)renova(dot)com(dot)pe> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ezequiel Luis Pellettieri 2007-02-06 02:26:03 Re: Moving a table to another directory
Previous Message Tom Lane 2007-02-05 21:49:10 Re: Symbol lookup error

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Jaime Casanova 2007-02-06 00:57:57 Re: Existe alguna función similar a DIFFERENCE() y SOUNDEX() de sql server en Postgres?
Previous Message Espartano 2007-02-05 22:55:17 Re: Fw: Cual Instalar ?? 8.2.2 o 8.1.4 en CentOS4.4