master.out

text/plain

Filename: master.out

Type: text/plain

Part: 1

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 
---------
      -1

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

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