Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 879B29FB3E2 for ; Sun, 11 Mar 2007 11:20:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 06187-08 for ; Sun, 11 Mar 2007 11:20:34 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.173]) by postgresql.org (Postfix) with ESMTP id 927399FA2C4 for ; Sun, 11 Mar 2007 11:20:34 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id k3so1813846ugf for ; Sun, 11 Mar 2007 07:20:33 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=ifSmN42uu52/LUqx12eTsgaU7TiR7KhXtvj5bmO/WK57o7OkYoIA6fWMzgqx0NHhyIhBgurUsQ19p8gm6zTU3gWJCnxcL0qTQgO0eauhkW4a1v667fJ/DzklsGr2ngnmkIvI4E9dnmpO6Z8NyhwBx6A9V7WtSzOq54uis52cBkY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=g/kwWWecTxQCBlh/w3cKhA1pZd7y+lMezRsDRH0uk7m7h4V8S9Cdbrk03X8wztCFifYX6Mvmt1wYUoRq5ShKXw99yWPM5aOoP5EAevVgM5ffefBWAhI/tYH6U9PKmgtObJKzIalbZ1qP6uKbTpHtrjyWkNUi4vhVAkIjgB4objs= Received: by 10.67.28.4 with SMTP id f4mr14913052ugj.1173622833134; Sun, 11 Mar 2007 07:20:33 -0700 (PDT) Received: by 10.67.94.13 with HTTP; Sun, 11 Mar 2007 07:20:33 -0700 (PDT) Message-ID: <55c095e90703110720o78dfcfeai2b31bbadf17582b7@mail.gmail.com> Date: Sun, 11 Mar 2007 11:20:33 -0300 From: "Ezequias Rodrigues da Rocha" To: PostgreSQL , Pgadmin-Support Subject: Alternative Serial MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_10651_29125263.1173622833086" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/40 X-Sequence-Number: 6755 ------=_Part_10651_29125263.1173622833086 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi list, I know that serials must be created like this. Create the Serial Create a field table and reffers to the pre-created serial. Now I noticed that it is possible to use the default value. I am almost quite sure that this is an alternative way and non polite. I would like to know if I am correct and what does it means: nextval('mySerial_id'::regclass) What is regclass ? Regards , -- Ezequias Rodrigues da Rocha http://ezequiasrocha.blogspot.com/ use Mozilla Firefox:http://br.mozdev.org/firefox/ ------=_Part_10651_29125263.1173622833086 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi list,

I know that serials must be created like this.

Create the Serial

Create a field table and reffers to the pre-created serial.

Now I noticed that it is possible to use the default value. I am almost quite sure that this is an alternative way and non polite.

I would like to know if I am correct and what does it means:

nextval('mySerial_id'::regclass)

What is regclass ?

Regards ,
--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use Mozilla Firefox:http://br.mozdev.org/firefox/ ------=_Part_10651_29125263.1173622833086--