Re: coalesce(json_agg [..] filter where [..], '[]' in left join returning null

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Stefan Houtzager <stefan(dot)houtzager(at)gmail(dot)com>
Cc: pgsql-novice <pgsql-novice(at)lists(dot)postgresql(dot)org>
Subject: Re: coalesce(json_agg [..] filter where [..], '[]' in left join returning null
Date: 2021-01-06 16:38:06
Message-ID: CAKFQuwZCuqZnyxzS6jqMdvi77DfgLfYpvcmN_WodAe1ZMg8Rjg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, Jan 6, 2021 at 9:32 AM Stefan Houtzager <stefan(dot)houtzager(at)gmail(dot)com>
wrote:

> Thanks again David. I am very novice, and tried the following which does
> not give an error but returns null instead of []
>

Please don't top-post here.

The general concept should work. You may at least wish to experiment in a
simple query to get the feel for the mechanics. With respect to this query
I'd probably need to have a working query to play with (and time) to give a
more precise answer.

David J.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Stefan Houtzager 2021-01-07 13:22:02 Re: coalesce(json_agg [..] filter where [..], '[]' in left join returning null
Previous Message Stefan Houtzager 2021-01-06 16:32:41 Re: coalesce(json_agg [..] filter where [..], '[]' in left join returning null