Received: from cortex.unice.fr (root@cortex.unice.fr [134.59.53.1]) by hub.org (8.8.8/8.7.5) with ESMTP id GAA01483 for ; Thu, 28 May 1998 06:05:05 -0400 (EDT) Received: from unice.fr (cortex.unice.fr [134.59.53.1]) by cortex.unice.fr (8.8.5/8.8.5) with ESMTP id MAA28437; Thu, 28 May 1998 12:01:07 +0200 Sender: jerome@cortex.unice.fr Message-ID: <356D35E3.3B5EC4A1@unice.fr> Date: Thu, 28 May 1998 10:01:07 +0000 From: Jerome ALET Reply-To: alet@unice.fr Organization: Faculte de Medecine de Nice X-Mailer: Mozilla 4.04 [en] (X11; I; Linux 2.0.33 sparc) MIME-Version: 1.0 To: patrice@idf.net CC: pgsql-sql@postgresql.org Subject: Re: [SQL] nextval References: Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Patrice Hédé wrote: > Maybe you should consider doing it with a default value as : > > CREATE TABLE auteurs (numero_auteur int4 default nextval('seq_auteurs'), > nom_auteur text, > prenom_auteur text, > email_auteur text > ); > > and then, you don't need to create a rule. > Yes, I already know that solution, but I wondered why mine was bad (the forgotten '') and finally I think I've found a (maybe already known) bug in CREATE RULE (look at the results in my previous message). Thanks. bye, Jerome ALET - alet@unice.fr - http://cortex.unice.fr/~jerome Faculte de Medecine de Nice - http://noe.unice.fr - Tel: 04 93 37 76 30 28 Avenue de Valombrose - 06107 NICE Cedex 2 - FRANCE