Re: [SQL] HELP: Scarey pl/pgsql problem

2001-02-05 Thread Tom Lane
Justin Clift <[EMAIL PROTECTED]> writes: > I'm having trouble with what MAY BE a bug in PL/PGSQL for PG 7.0.3 on > Linux (Mandrake Linux 7.2). > [ bogus roundoff behavior in date/time display ] This is a known silliness in the Mandrake distribution: their default compiler flags include both -O3 a

[SQL] HELP: Scarey pl/pgsql problem

2001-02-05 Thread Justin Clift
Hi all, I'm having trouble with what MAY BE a bug in PL/PGSQL for PG 7.0.3 on Linux (Mandrake Linux 7.2). It appears pl/pgsql is munging values. When I pass it a 'time' value, the value is altered without my code touching it. This is evidenced by the stripped down function below : CREATE FUNC