create index on a field of udt

From: Shujie Shang <sshang(at)pivotal(dot)io>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: create index on a field of udt
Date: 2015-06-29 05:08:51
Message-ID: CAJrojKX40b_iQp2myz-1UHVOxo7shfpVV_HjgGQVFEQ5u_cA0Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, All:
I want to create a index on one field of udt, how can I do that?
e.g
create type info as (id int, name text);
I want to create index on info.id.

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2015-06-29 05:23:34 Re: create index on a field of udt
Previous Message Dave Johansen 2015-06-29 04:32:45 Re: Inserting from multiple processes?