Re: [BUGS] Daylight saving bug in PostgreSQL 7.2.1 ?

2003-07-12 Thread Jacek Kalinski
Dnia 07/12/2003 04:54 AM, Jonas Lindholm napisaƂ(a): Hi! I believe I've found a bug with daylight saving time. The example below shows that after inserting a row with a date and time when daylight saving is changing (6 April 2003 02:00:00) any selects using the same time and date are only return

Re: [BUGS] Daylight saving bug in PostgreSQL 7.2.1 ?

2003-07-12 Thread Tom Lane
Jonas Lindholm <[EMAIL PROTECTED]> writes: > I believe I've found a bug with daylight saving time. I cannot reproduce this here, using either 7.2.4 or current. regards, tom lane ---(end of broadcast)--- TIP 8: explain analyz

[BUGS] Function immutable is not during a reindex ?

2003-07-12 Thread Mendola Gaetano
Hi all, I'm running the followin example on Postgres 7.3.3 I notice that if I declare an immutable function like this: CREATE OR REPLACE FUNCTION test (integer) RETURNS integer AS ' declare begin raise notice ''test called''; return $1+1; end;' LANGUAGE plpgsql IMMUTABLE; and I use this func

Re: [BUGS] [ADMIN] Function immutable is not during a reindex ?

2003-07-12 Thread Tom Lane
"Mendola Gaetano" <[EMAIL PROTECTED]> writes: > the function is immutable but is executed 3 times > ( one for each row). So? Sounds to me like it's working as intended. regards, tom lane ---(end of broadcast)--- TIP 6: Have