From: | "Anton Stckl" <tony(at)cys(dot)de> |
---|---|
To: | alet(at)unice(dot)fr |
Cc: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | Re: [SQL] nextval |
Date: | 1998-05-27 15:33:46 |
Message-ID: | 356C325A.79DDFCD3@cys.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)cys(dot)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-------
From | Date | Subject | |
---|---|---|---|
Next Message | Patrice Hédé | 1998-05-27 15:37:32 | Re: [SQL] nextval |
Previous Message | Dirk Lutzebaeck | 1998-05-27 14:35:14 | SELECT across two databases |