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 6E46B30ED1B for ; Mon, 16 Jun 2003 14:54:04 +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 38322-09 for ; Mon, 16 Jun 2003 11:53:54 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 92F3A30ED14 for ; Mon, 16 Jun 2003 11:53:53 -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 h5GErpU6002972; Mon, 16 Jun 2003 10:53:51 -0400 (EDT) To: Tomasz Myrta Cc: PGSQL-SQL Subject: Re: casting interval to time In-reply-to: <3EEDCB67.4090504@klaster.net> References: <3EEDCB67.4090504@klaster.net> Comments: In-reply-to Tomasz Myrta message dated "Mon, 16 Jun 2003 15:51:35 +0200" Date: Mon, 16 Jun 2003 10:53:51 -0400 Message-ID: <2971.1055775231@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200306/143 X-Sequence-Number: 13901 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? regards, tom lane