Re: BUG #1517: SQL interval syntax is accepted by the parser,

From: Roy Badami <roy(at)gnomon(dot)org(dot)uk>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Roy Badami <roy(at)gnomon(dot)org(dot)uk>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1517: SQL interval syntax is accepted by the parser,
Date: 2005-03-24 10:15:44
Message-ID: 16962.37712.416185.632728@giles.gnomon.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


test=> select interval '1 hour 1 minute';
interval
----------
01:01:00
(1 row)

Hmm, I don't think I really like having a seconds field in the output,
given that the column is by definition only storing data to a
precision of a minute.

-roy

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Joerg Ertl 2005-03-24 10:54:37 BUG #1560: Service does not start
Previous Message Andrew - Supernews 2005-03-24 09:14:25 Re: BUG #1552: massive performance hit between 7.4 and 8.0.1