Home > mailing lists

create index on a field of udt - Mailing list pgsql-general

From	Shujie Shang
Subject	create index on a field of udt
Date	June 29, 2015 08:08:58
Msg-id	CAJrojKX40b_iQp2myz-1UHVOxo7shfpVV_HjgGQVFEQ5u_cA0Q@mail.gmail.com Whole thread Raw
Responses	Re: create index on a field of udt
List	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

From: Dave Johansen
Date: 29 June 2015, 07:32:55
Subject: Re: Inserting from multiple processes?

From: John R Pierce
Date: 29 June 2015, 08:23:53
Subject: Re: create index on a field of udt