Create index on user defined type

From: aditya desai <admad123(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Create index on user defined type
Date: 2022-04-19 16:27:18
Message-ID: CAN0SRDHgW+5-yGdLE-y6eCpWdffV7iexabGL1PmZOb7BU=QeWg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christophe Pettus 2022-04-19 16:29:37 Re: Create index on user defined type
Previous Message João Paulo Almeida 2022-04-14 09:10:18 Understanding SQL queries