X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id A246830EEFB for ; Mon, 16 Jun 2003 15:17:25 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 40455-07 for ; Mon, 16 Jun 2003 12:17:14 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 4D3DC30EEE9 for ; Mon, 16 Jun 2003 12:17:14 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h5GFHCU6003223; Mon, 16 Jun 2003 11:17:12 -0400 (EDT) To: Tomasz Myrta Cc: PGSQL-SQL Subject: Re: casting interval to time In-reply-to: <3EEDDB8D.5080401@klaster.net> References: <3EEDCB67.4090504@klaster.net> <2971.1055775231@sss.pgh.pa.us> <3EEDDB8D.5080401@klaster.net> Comments: In-reply-to Tomasz Myrta message dated "Mon, 16 Jun 2003 17:00:29 +0200" Date: Mon, 16 Jun 2003 11:17:11 -0400 Message-ID: <3222.1055776631@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200306/146 X-Sequence-Number: 13904 Tomasz Myrta writes: > Dnia 2003-06-16 16:53, Użytkownik Tom Lane napisał: >> Tomasz Myrta 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