From: Jerome ALET <alet@unice.fr>
To: patrice@idf.net
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] nextval
Date: Thu, 28 May 1998 10:01:07 +0000
Message-ID: <356D35E3.3B5EC4A1@unice.fr> (raw)
References: <Pine.LNX.3.96.980528114405.29416A-100000@paris.ivo.fr>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: alet@unice.fr, patrice@idf.net
Subject: Re: [SQL] nextval
In-Reply-To: <356D35E3.3B5EC4A1@unice.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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