Changes between Initial Version and Version 1 of Ticket #34255, comment 4


Ignore:
Timestamp:
Jan 12, 2023, 10:34:30 PM (21 months ago)
Author:
Simon Charette

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #34255, comment 4

    initial v1  
    22
    33In other words, the problem is not about grouping by alias or column index but grouping by an expression that is elided from the select clause and thus cannot be grouped by reference.
     4
     5We need to perform so column masking for the query to ensure the query keeps its semanti
     6
     7{{{#!sql
     8SELECT baseload FROM (
     9    SELECT
     10        EXTRACT(YEAR FROM "ticket_34255_point"."start_at" AT TIME ZONE 'Europe/Paris') AS "year",
     11        AVG("ticket_34255_point"."value") AS "baseload"
     12    FROM "ticket_34255_point"
     13    GROUP BY 1
     14)
     15}}}
Back to Top