pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How to quietly increment a SEQUENCE?
2+ messages / 2 participants
[nested] [flat]

* How to quietly increment a SEQUENCE?
@ 2000-02-10 17:59  Martin Kresse <mkresse@slyde.in-berlin.de>
  0 siblings, 1 reply; 2+ messages in thread

From: Martin Kresse @ 2000-02-10 17:59 UTC (permalink / raw)
  To: pgsql-sql

Hi there,

How can I (quietly) increment a SEQUENCE without having to use 
SELECT, or is there a way to dump the result of a query (SELECT 
NEXTVAL('...'))?

Thanks for your help,
  Martin Kresse




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

* Re: [SQL] How to quietly increment a SEQUENCE?
@ 2000-02-10 18:29  Bruce Momjian <pgman@candle.pha.pa.us>
  parent: Martin Kresse <mkresse@slyde.in-berlin.de>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruce Momjian @ 2000-02-10 18:29 UTC (permalink / raw)
  To: Martin Kresse <mkresse@slyde.in-berlin.de>; +Cc: pgsql-sql

> Hi there,
> 
> How can I (quietly) increment a SEQUENCE without having to use 
> SELECT, or is there a way to dump the result of a query (SELECT 
> NEXTVAL('...'))?

SELECT next_val('seqname');


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



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


end of thread, other threads:[~2000-02-10 18:29 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-02-10 17:59 How to quietly increment a SEQUENCE? Martin Kresse <mkresse@slyde.in-berlin.de>
2000-02-10 18:29 ` Bruce Momjian <pgman@candle.pha.pa.us>

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