bug? incorrect return type from extract
Started by Pavel Stehuleover 22 years ago2 messagesgeneral
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
