bug? incorrect return type from extract

From: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: bug? incorrect return type from extract
Date: 2003-07-28 05:17:08
Message-ID: Pine.LNX.4.44.0307280710490.19383-100000@kix.fsv.cvut.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-07-28 05:22:46 Re: [ANNOUNCE] v7.3.4 Bug Fix Release
Previous Message LitelWang 2003-07-28 04:44:26 Re: unicode char order