Re: casting interval to time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tomasz Myrta <jasiek(at)klaster(dot)net>
Cc: PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: casting interval to time
Date: 2003-06-16 15:17:11
Message-ID: 3222.1055776631@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tomasz Myrta <jasiek(at)klaster(dot)net> writes:
> Dnia 2003-06-16 16:53, Uytkownik Tom Lane napisa:
>> Tomasz Myrta <jasiek(at)klaster(dot)net> 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 package. I got the same result even on a 7.3.3 Debian
> package.

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?

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-06-16 15:37:03 Re: [pgmail] - I have problems with pgmail
Previous Message Tomasz Myrta 2003-06-16 15:00:29 Re: casting interval to time