Re: BUG #1518: Conversions to (undocumented) SQL year-month and - Mailing list pgsql-bugs

From Roy Badami
Subject Re: BUG #1518: Conversions to (undocumented) SQL year-month and
Date
Msg-id 16961.56392.618908.323750@giles.gnomon.org.uk
Whole thread Raw
In response to Re: BUG #1518: Conversions to (undocumented) SQL year-month and  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: BUG #1518: Conversions to (undocumented) SQL year-month and  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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

pgsql-bugs by date:

Previous
From: Sergio Lob
Date:
Subject: Re: Precision and scale of numeric column reported as value
Next
From: Alvaro Herrera
Date:
Subject: Re: Precision and scale of numeric column reported as value