Re: BUG #1518: Conversions to (undocumented) SQL year-month and

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>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1518: Conversions to (undocumented) SQL year-month and
Date: 2005-03-23 21:14:48
Message-ID: 16961.56392.618908.323750@giles.gnomon.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Bruce> Seems that is implentation-dependent so I added "round' or
Bruce> error" to the TODO item.

Ah, OK. "A guide to the SQL standard" claims it's an exception, but I
haven't checked the actual standard.

Bruce> Uh, I think this already works fine for PG syntax, and I
Bruce> assume once we support ANSI syntax it will work fine too:

I guess. It's just that it's something that EXTRACT doesn't currently
have to worry about, so it would be easy to overlook.

-roy

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2005-03-23 21:25:05 Re: Precision and scale of numeric column reported as value
Previous Message Sergio Lob 2005-03-23 21:13:22 Re: Precision and scale of numeric column reported as value