patch3.out

text/plain

Filename: patch3.out

Type: text/plain

Part: 3

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