On Wed, Sep 13, 2023 at 10:53 AM JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
wrote:
> I need to return more than 1 field on each WHEN and also assign an ALIAS.
>
>
You can only produce a single value of a specific data type from the output
of a case expression. To do what you desire, create a custom composite
type and return that. You get to name the fields when you define the
composite type.
David J.