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.