MIME-Version: 1.0
From: aditya desai <admad123@gmail.com>
Date: Tue, 19 Apr 2022 21:57:18 +0530
Message-ID: 
 <CAN0SRDHgW+5-yGdLE-y6eCpWdffV7iexabGL1PmZOb7BU=QeWg@mail.gmail.com>
Subject: Create index on user defined type
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005ac06105dd045a00"
Archived-At: 
 <https://www.postgresql.org/message-id/CAN0SRDHgW%2B5-yGdLE-y6eCpWdffV7iexabGL1PmZOb7BU%3DQeWg%40mail.gmail.com>
Precedence: bulk

--0000000000005ac06105dd045a00
Content-Type: text/plain; charset="UTF-8"

Hi,
Is there any way to create index on user defined type in Postgresql? Need
to create index on bug_status in bug table.

CREATE TYPE bug_status AS ENUM ('new', 'open', 'closed');

CREATE TABLE bug (
    id serial,
    description text,
    status bug_status
);

Regards,
Aditya.

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

<div dir=3D"ltr"><div dir=3D"ltr">Hi,<div>Is there any way to create index =
on user defined type in Postgresql? Need to create index on bug_status in b=
ug table.</div><div><br></div><div><div>CREATE TYPE bug_status AS ENUM (=
9;new&#39;, &#39;open&#39;, &#39;closed&#39;);</div><div><br></div><div>CRE=
ATE TABLE bug (</div><div>=C2=A0 =C2=A0 id serial,</div><div>=C2=A0 =C2=A0 =
description text,</div><div>=C2=A0 =C2=A0 status bug_status</div><div>);</d=
iv></div><div><br></div><div>Regards,</div><div>Aditya.</div></div></div>

--0000000000005ac06105dd045a00--