Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y - Mailing list pgsql-general

On Fri, 3 Mar 2023, Alban Hertroys wrote:

>You can rewrite that into something like this:
>
>select jsonb_build_object('opening_times’,
>    obj
>    ORDER BY
>        obj->>'weekday’,
>        obj->>'from_hour’,
>        obj->>'to_hour')
>)
>from cot
>cross join lateral jsonb_agg(jsonb_build_object(
>        'weekday', cot.weekday,
>        'from_hour', cot.from_hour,
>        'to_hour', cot.to_hour) obj

But isn’t that the same as with a regular LEFT JOIN?

>>    cgwaj AS (
>>     SELECT cgwa.id AS id, jsonb_build_object(
>>         'weekday', cgwa.weekday,
>>         'forenoon', cgwa.forenoon,
>>         'afternoon', cgwa.afternoon,
>>         'evening', cgwa.evening) AS obj
>>     FROM core_generalworkavailability cgwa

plus

>>     LEFT JOIN cgwaj ON cgwaj.id=cppwt.generalworkavailability_id

With the addition that I can aggregate…

bye,
//mirabilos
--
15:41⎜<Lo-lan-do:#fusionforge> Somebody write a testsuite for helloworld :-)