Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\))
Subject: Re: Create index on user defined type
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: 
 <CAN0SRDHgW+5-yGdLE-y6eCpWdffV7iexabGL1PmZOb7BU=QeWg@mail.gmail.com>
Date: Tue, 19 Apr 2022 09:29:37 -0700
Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <4D6ADD6D-0E11-4E6C-BF6D-AFB57FFF1B67@thebuild.com>
References: 
 <CAN0SRDHgW+5-yGdLE-y6eCpWdffV7iexabGL1PmZOb7BU=QeWg@mail.gmail.com>
To: aditya desai <admad123@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/4D6ADD6D-0E11-4E6C-BF6D-AFB57FFF1B67%40thebuild.com>
Precedence: bulk


> On Apr 19, 2022, at 09:27, aditya desai <admad123@gmail.com> wrote:
>=20
> Hi,
> Is there any way to create index on user defined type in Postgresql? =
Need to create index on bug_status in bug table.
>=20
> CREATE TYPE bug_status AS ENUM ('new', 'open', 'closed');
>=20
> CREATE TABLE bug (
>     id serial,
>     description text,
>     status bug_status
> );

It works right out of the box:

xof=3D# CREATE TYPE bug_status AS ENUM ('new', 'open', 'closed');
CREATE TYPE
xof=3D# CREATE TABLE bug (
    id serial,
    description text,
    status bug_status
);
CREATE TABLE
xof=3D# create index on bug(status);
CREATE INDEX
xof=3D#=20