Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 9B25B4761CD
	for <pgsql-sql@postgresql.org>; Mon, 11 Nov 2002 09:42:58 -0500 (EST)
Received: from mx2.mail.ru (mx2.mail.ru [194.67.57.12])
	by postgresql.org (Postfix) with ESMTP id 9C5AA4760C9
	for <pgsql-sql@postgresql.org>; Mon, 11 Nov 2002 09:42:57 -0500 (EST)
Received: from drweb by mx2.mail.ru with drweb-scanned (Exim MX.2)
	id 18BFmF-000O6r-00; Mon, 11 Nov 2002 17:42:59 +0300
Received: from [213.128.193.142] (helo=mail.ru)
	by mx2.mail.ru with esmtp (Exim SMTP.2)
	id 18BFmC-000O3v-00; Mon, 11 Nov 2002 17:42:56 +0300
Message-ID: <3DCFC1ED.7060908@mail.ru>
Date: Mon, 11 Nov 2002 17:42:53 +0300
From: dima <_pppp@mail.ru>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.0.0) Gecko/20020816
X-Accept-Language: ru, en-us, en
MIME-Version: 1.0
To: Carlos Sousa <carlosdsousa@hotmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: small problem
References: <F214ek2ig4yorAxCT9E00005b5c@hotmail.com>
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/162
X-Sequence-Number: 10304

> create table (...)
> (...)
> duration   interval default 7
do you really think it's worth spending 12 bytes for your intervals?
i usually use either timestamps or integers for intervals.
btw, as i know default 7 would be 7 msecs :)

> hourDay    timestamp with time zome
consider using it without a time zone maybe.
if you really mean time of a day use time [with time zone]

> (...)
> 
> 
> if i replace this two data types with varchar2(50) it works but i would 
> like if there's a better choice
it seems oracle still has some probs with sql date/time data types...