pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: identity es postgresql
4+ messages / 2 participants
[nested] [flat]

* Re: identity es postgresql
@ 2007-02-04 05:11  Jaime Casanova <systemguards@gmail.com>
  parent: jeferson alvarez <jalvarez@renova.com.pe>
  0 siblings, 1 reply; 4+ messages in thread

From: Jaime Casanova @ 2007-02-04 05:11 UTC (permalink / raw)
  To: jeferson alvarez <jalvarez@renova.com.pe>; +Cc: pgsql-es-ayuda@postgresql.org

On 2/15/07, jeferson alvarez <jalvarez@renova.com.pe> 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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: identity es postgresql
@ 2007-02-06 00:45  Jaime Casanova <systemguards@gmail.com>
  parent: Jaime Casanova <systemguards@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Jaime Casanova @ 2007-02-06 00:45 UTC (permalink / raw)
  To: jeferson alvarez <jalvarez@renova.com.pe>; +Cc: Postgres EspaƱol <pgsql-es-ayuda@postgresql.org>

Siempre con copia a la lista por favor

On 2/5/07, jeferson alvarez <jalvarez@renova.com.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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: identity es postgresql
@ 2007-02-06 12:08  jeferson alvarez <jalvarez@renova.com.pe>
  parent: Jaime Casanova <systemguards@gmail.com>
  0 siblings, 0 replies; 4+ messages in thread

From: jeferson alvarez @ 2007-02-06 12:08 UTC (permalink / raw)
  To: Jaime Casanova <systemguards@gmail.com>; pgsql-es-ayuda@postgresql.org

gracias salio bien
>




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* identity es postgresql
@ 2007-02-15 17:22  jeferson alvarez <jalvarez@renova.com.pe>
  0 siblings, 1 reply; 4+ messages in thread

From: jeferson alvarez @ 2007-02-15 17:22 UTC (permalink / raw)
  To: pgsql-es-ayuda@postgresql.org

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2007-02-15 17:22 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-02-15 17:22 identity es postgresql jeferson alvarez <jalvarez@renova.com.pe>
2007-02-04 05:11 ` Jaime Casanova <systemguards@gmail.com>
2007-02-06 00:45   ` Jaime Casanova <systemguards@gmail.com>
2007-02-06 12:08     ` jeferson alvarez <jalvarez@renova.com.pe>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox