On Mon, Dec 20, 2021 at 3:24 PM Ray O'Donnell wrote:
> On 20 December 2021 22:10:19 Shaozhong SHI wrote:
>
>> Is there a way to turn select result into something like 'a|b|c' .
>> Regards,
>> David
>>
>
> On my phone so hard to reply properly, but if a, b and c are in separate
> rows then you ne
On 20 December 2021 22:10:19 Shaozhong SHI wrote:
Is there a way to turn select result into something like 'a|b|c' .
Regards,
David
On my phone so hard to reply properly, but if a, b and c are in separate
rows then you need the array_agg() and array_to_string() functions.
Ray.
Is there a way to turn select result into something like 'a|b|c' .
Regards,
David