MIME-Version: 1.0
References: 
 <CAAY=A78qufOUD+GLZVjNwLgBer2DxtJsHrc3h7H8r33_yuhrTw@mail.gmail.com>
In-Reply-To: 
 <CAAY=A78qufOUD+GLZVjNwLgBer2DxtJsHrc3h7H8r33_yuhrTw@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Wed, 13 Sep 2023 11:07:05 -0700
Message-ID: 
 <CAKFQuwa5n3OOz2-i7T=9oLfHNUxipeEAzFBXz2OETnOL3BX6xQ@mail.gmail.com>
Subject: Re: Query with conditional statement
To: JORGE MALDONADO <jorgemal1960@gmail.com>
Cc: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000611af90605416e62"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwa5n3OOz2-i7T%3D9oLfHNUxipeEAzFBXz2OETnOL3BX6xQ%40mail.gmail.com>
Precedence: bulk

--000000000000611af90605416e62
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Sep 13, 2023 at 10:53=E2=80=AFAM JORGE MALDONADO <jorgemal1960@gmai=
l.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.

--000000000000611af90605416e62
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Wed, Sep 13, 2023 at 10:53=E2=80=AFAM JORGE MALDONADO &=
lt;<a href=3D"mailto:jorgemal1960@gmail.com">jorgemal1960@gmail.com</a>&gt;=
 wrote:</span></div></div><div class=3D"gmail_quote"><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204=
,204,204);padding-left:1ex"><div dir=3D"ltr"><div>I need to return more tha=
n 1 field on each WHEN and also assign an ALIAS.</div><div><br></div></div>=
</blockquote><div><br></div><div class=3D"gmail_default" style=3D"font-fami=
ly:arial,helvetica,sans-serif">You can only produce a single value of a spe=
cific data type from the output of a case expression.=C2=A0 =C2=A0To do wha=
t you desire, create a custom composite type and return that.=C2=A0 You get=
 to name the fields when you define the composite type.</div><div class=3D"=
gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><br></div><=
div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif=
">David J.</div><div class=3D"gmail_default" style=3D"font-family:arial,hel=
vetica,sans-serif"><br></div></div></div>

--000000000000611af90605416e62--