Re: [SQL] nextval - Mailing list pgsql-sql

From Anton Stöckl
Subject Re: [SQL] nextval
Date
Msg-id 356C325A.79DDFCD3@cys.de
Whole thread Raw
In response to nextval  (Jerome ALET <alet@unice.fr>)
List pgsql-sql
Jerome ALET wrote:

> CREATE RULE rule_i_slogans AS ON INSERT TO slogans DO UPDATE NEW SET
> numero_slogan = nextval(seq_slogans) , points_slogan = 10;
> ERROR:  attribute 'seq_slogans' not found

CREATE RULE rule_i_slogans AS ON INSERT TO slogans DO UPDATE NEW SET
numero_slogan = nextval('seq_slogans') , points_slogan = 10;
                        ^           ^

have fun, Tony

--
----------C-Y-B-E-R-S-O-L-U-T-I-O-N-S----------------
Anton Stöckl                    mailto:tony@cys.de
CyberSolutions GmbH             http://www.cys.de
Frankfurter Ring 193A           Phone +49 89 32369223
80807 Muenchen                  Fax   +49 89 32369220
------W-E----M-A-K-E----I-T----P-O-S-S-I-B-L-E-------

pgsql-sql by date:

Previous
From: Dirk Lutzebaeck
Date:
Subject: SELECT across two databases
Next
From: Patrice Hédé
Date:
Subject: Re: [SQL] nextval