Postgres Pro
Downloads
Home   >   mailing lists

Create index on user defined type - Mailing list pgsql-sql

From aditya desai
Subject Create index on user defined type
Date
Msg-id CAN0SRDHgW+5-yGdLE-y6eCpWdffV7iexabGL1PmZOb7BU=QeWg@mail.gmail.com
Whole thread Raw
Responses Re: Create index on user defined type  (Christophe Pettus <xof@thebuild.com>)
List pgsql-sql
Tree view
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.

pgsql-sql by date:

Previous
From: João Paulo Almeida
Date:
Subject: Understanding SQL queries
Next
From: Christophe Pettus
Date:
Subject: Re: Create index on user defined type