Received: from shaked.cc.openu.ac.il (shaked.cc.openu.ac.il [147.233.145.65]) by hub.org (8.8.8/8.7.5) with ESMTP id LAA08521 for ; Tue, 18 Aug 1998 11:26:50 -0400 (EDT) Received: from [147.233.159.109] (herouth@mac-herouth.pc.openu.ac.il [147.233.159.109]) by shaked.cc.openu.ac.il (8.8.5/8.8.5) with ESMTP id SAA12249; Tue, 18 Aug 1998 18:26:16 +0300 (IDT) X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <35D9924F.3506064E@christianianett.no> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Tue, 18 Aug 1998 18:27:20 +0300 To: Roy Sigurd Karlsbakk From: Herouth Maoz Subject: Re: [GENERAL] The use of sequences Cc: pgsql-sql@postgreSQL.org At 17:40 +0300 on 18/8/98, Roy Sigurd Karlsbakk wrote: > > Could somebody tell me how I can make efficient use of sequences? I am > familiar with Oracle's sequences and they usually work as the following > example: > INSERT INTO PERSON table(some_sequence.nextval,data,data,data); > > How do they work in postgreSQL? Look in the manpage of create_sequence Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma