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 E8BF930EE6E for ; Mon, 16 Jun 2003 15:00:22 +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 40312-04 for ; Mon, 16 Jun 2003 12:00:12 -0300 (ADT) Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by svr1.postgresql.org (Postfix) with ESMTP id 5D9AA30EE87 for ; Mon, 16 Jun 2003 12:00:12 -0300 (ADT) Received: from klaster.net (tv126.internetdsl.tpnet.pl [80.55.125.126]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id 0BB9D2B3D2; Mon, 16 Jun 2003 17:00:10 +0200 (CEST) Message-ID: <3EEDDB8D.5080401@klaster.net> Date: Mon, 16 Jun 2003 17:00:29 +0200 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: Tom Lane Cc: PGSQL-SQL Subject: Re: casting interval to time References: <3EEDCB67.4090504@klaster.net> <2971.1055775231@sss.pgh.pa.us> In-Reply-To: <2971.1055775231@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Archive-Number: 200306/144 X-Sequence-Number: 13902 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. postgresql.conf contains: DATESTYLE = 'iso,european' LC_MESSAGES = 'C' LC_MONETARY = 'C' LC_NUMERIC = 'C' LC_TIME = 'C' Regards, Tomasz Myrta