bug? incorrect return type from extract - Mailing list pgsql-general

From Pavel Stehule
Subject bug? incorrect return type from extract
Date
Msg-id Pine.LNX.4.44.0307280710490.19383-100000@kix.fsv.cvut.cz
Whole thread Raw
Responses Re: bug? incorrect return type from extract  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hello

Is correct so extract(day from current_date) return double? I need
explicit cast for this expression

current_date - extract(day from current_date) + 1 -- don't work

ERROR:  operator does not exist: date - double precision
HINT:  No operator matches the given name and argument type(s). You may
need to add explicit typecasts.

why? I have cvs PostgreSQL updated 23.7.

regards,
Pavel Stehule


pgsql-general by date:

Previous
From: "LitelWang"
Date:
Subject: Re: unicode char order
Next
From: Tom Lane
Date:
Subject: Re: [ANNOUNCE] v7.3.4 Bug Fix Release