[EMAIL PROTECTED] writes:
> I have found some inconsistencies relating to TIMESTAMP arithmetic.
I dug into this a little, and what seems to be causing the inconsistency
is a surprising implicit coercion.
> select now()-'2001-09-30' where (now()-'2001-09-30') < 50;
>> returned 0 rows
I did this
[EMAIL PROTECTED] writes:
> CREATE RULE insert_test2 AS ON INSERT TO test1 DO INSERT INTO test2
> (sum1, name2, id, id1) VALUES (new.sum, new.name, new.id,
> nextval('"test2_id1_seq"'::text));
"NEW" is a macro, not a variable. This rule will be expanded to
something like
INSERT INTO test2
(sum1
On Wed, 17 Oct 2001 [EMAIL PROTECTED] wrote:
> Tony Tomov ([EMAIL PROTECTED]) reports a bug with a severity of 2
> The lower the number the more severe it is.
>
> Short Description
> strange behavior when creting rules with serial id
>
> Long Description
> I do not know if this is a bug, but f
I do not know if this is a bug, but for me this is a strange behavior.
I will describe the following process.
CREATE TABLE "test1" (
"id" SERIAL,
"sum" numeric ,
"name" char (20) ,
PRIMARY KEY ("id"), UNIQUE ("id"));
CREATE TABLE "test2" (
"id1" SERIAL,
"sum1" numeric ,
"name2" char (20) ,
PRIMA
