Received: from mail.christianianett.no (mp-220-10.daxnet.no [193.216.220.10]) by hub.org (8.8.8/8.7.5) with ESMTP id KAA04345 for ; Tue, 18 Aug 1998 10:40:19 -0400 (EDT) Received: from christianianett.no (mp-221-70.daxnet.no [193.216.221.70]) by mail.christianianett.no (8.8.7/8.8.7) with ESMTP id QAA22048 for ; Tue, 18 Aug 1998 16:40:04 +0200 Message-ID: <35D9924F.3506064E@christianianett.no> Date: Tue, 18 Aug 1998 16:40:16 +0200 From: Roy Sigurd Karlsbakk Organization: ChristianiaNett A/S X-Mailer: Mozilla 4.5b1 [en] (Win95; I) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-general@postgreSQL.org" Subject: The use of sequences Content-Type: multipart/mixed; boundary="------------FC80D9AADA19F0DE6931F327" This is a multi-part message in MIME format. --------------FC80D9AADA19F0DE6931F327 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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? Roy -- Roy Sigurd Karlsbakk - MCSE, CNE, CLS, ASE - ChristianiaNett A/S, Akersgt. 11, 0158 OSLO, +47 2247 3100 http://www.christianianett.no/ (norwegian) --------------FC80D9AADA19F0DE6931F327 Content-Type: text/x-vcard; charset=us-ascii; name="roy.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Roy Sigurd Karlsbakk Content-Disposition: attachment; filename="roy.vcf" begin:vcard n:Karlsbakk;Roy Sigurd x-mozilla-html:FALSE org:ChristianiaNett A/S version:2.1 email;internet:roy@christianianett.no title:Seniorkonsulent x-mozilla-cpt:;0 fn:Roy Sigurd Karlsbakk end:vcard --------------FC80D9AADA19F0DE6931F327--