On Thu, 1 May 2025 at 00:29, PALAYRET Jacques wrote:
> => In the subquery, the semantic analysis of the query considers the column "
> dat " instead of the expression " to_char(dat,'mm') ", which is actually
> a grouped column.
> Is this normal? How can I simply resolve the problem?
Calcula
Hello,
I have an unexpected error in my following query (of course, the query has been
simplified here to request help):
SELECT num_poste, to_char(dat, 'MM')::integer dat, CASE
FLOOR((TO_NUMBER(TO_CHAR(dat,'DD'),'99')-1)/10) WHEN 0 THEN 1 WHEN 1 THEN 2
ELSE 3 END::smallint AS num_decade
