Hi
psql -V
psql (PostgreSQL) 7.3
SELECT cast(cast('1 day 12 hours' as interval) as time);
time
--
12:00:00
(1 row)
psql -V
psql (PostgreSQL) 7.3.2
SELECT cast(cast('1 day 12 hours' as interval) as time);
time
--
00:00:00
(1 row)
Did I miss something? I looked into 'history'
Tomasz Myrta [EMAIL PROTECTED] writes:
psql (PostgreSQL) 7.3.2
SELECT cast(cast('1 day 12 hours' as interval) as time);
time
--
00:00:00
(1 row)
I get 12:00:00 here, using 7.3.3 ... platform-specific problem maybe?
regards, tom lane
Dnia 2003-06-16 16:53, Uytkownik Tom Lane napisa:
Tomasz Myrta [EMAIL PROTECTED] writes:
psql (PostgreSQL) 7.3.2
SELECT cast(cast('1 day 12 hours' as interval) as time);
time
--
00:00:00
(1 row)
I get 12:00:00 here, using 7.3.3 ... platform-specific problem maybe?
Default Debian
Tomasz Myrta [EMAIL PROTECTED] writes:
Dnia 2003-06-16 16:53, U¿ytkownik Tom Lane napisa³:
Tomasz Myrta [EMAIL PROTECTED] writes:
psql (PostgreSQL) 7.3.2
SELECT cast(cast('1 day 12 hours' as interval) as time);
time
--
00:00:00
(1 row)
I get 12:00:00 here, using 7.3.3 ...
On Mon, 16 Jun 2003, Tom Lane wrote:
Tomasz Myrta [EMAIL PROTECTED] writes:
Dnia 2003-06-16 16:53, U¿ytkownik Tom Lane napisa³:
Tomasz Myrta [EMAIL PROTECTED] writes:
psql (PostgreSQL) 7.3.2
SELECT cast(cast('1 day 12 hours' as interval) as time);
time
--
Dnia 2003-06-16 17:17, Uytkownik Tom Lane napisa:
What do you get from pg_config --configure? What's the hardware
platform --- i386, or something else? Can anyone else reproduce this,
on any platform?
The platform is i386.
There was no pg_config file in binary package. After copying this file
Antti Haapala [EMAIL PROTECTED] writes:
'--enable-integer-datetimes' (could be this?)
Bingo. I can reproduce it with that configure choice.
Should have the answer soon ...
regards, tom lane
---(end of broadcast)---
TIP
Antti Haapala [EMAIL PROTECTED] writes:
It's also Debian (3.0).
On investigation the interval_time() function was completely broken for
the --enable-integer-datetimes case --- it was reducing the interval
value modulo one second, rather than modulo one day as intended.
I also noticed that