How unique PK value in Postgres?
aclay at mac.com
Thu Feb 3 10:43:07 UTC 2022
On Feb 2, 2022, at 11:17, Doug Easterbrook <doug at artsman.com> wrote:
> for example, we have functions that determine some visible icons to display in lists. The returning clause can look like
> getIconForPatron(CLIENT) as icon,
> case when BALANCE>0 then ‘owes’ end as BalanceIndicator,
> (select count(*) from emailRecord where CLIENT.client_seq=EMAIL.client_seq) as emailCount
> the ’select’ statement in the returning clause lets me join data from other tables for the rows returned. handy, if you need it.
Mind. blown. Doug, I owe you drink!
More information about the omnisdev-en