Re: From Clause Conditional

2023-02-02 Thread Tom Lane
Zahir Lalani writes: > LEFT JOIN lateral ( > SELECT > CASE > WHEN (0 > 0) THEN > convert_from(crypto_secretbox_open, 'utf8')::JSON > ELSE > NULL > END AS edata > FROM > crypto_secretbox_open(coalesce(null, > '')::bytea, coalesce(null

Re: From Clause Conditional

2023-02-02 Thread Erik Wienhold
> On 02/02/2023 13:54 CET Zahir Lalani wrote: > > Confidential > > Hello All > > We are testing a upgrade from pg11 to pg14 and have some issues to overcome. > One of these is that we have upgraded pgsodium to the latest and there is a > functional change – this question is not about sodium BTW. >

From Clause Conditional

2023-02-02 Thread Zahir Lalani
Confidential Hello All We are testing a upgrade from pg11 to pg14 and have some issues to overcome. One of these is that we have upgraded pgsodium to the latest and there is a functional change - this question is not about sodium BTW. So here is a sample bit of code that I will use to explain