patch2.out

text/plain

Filename: patch2.out

Type: text/plain

Part: 2

Message: Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL);

SELECT extract(quarter FROM interval '18 months');
 extract 
---------
       3

SELECT extract(quarter FROM interval '-18 months');
 extract 
---------
      -3

SELECT extract(quarter FROM interval '-18 months -600 days');
 extract 
---------
      -3

SELECT extract(quarter FROM interval '-600 days');
 extract 
---------
       1