On 6/28/2015 10:31 PM, Shujie Shang wrote:
> Oh, I didn't explain my question well, actually I want to create an
> index on an udt in a table.
>
> e.g.
> create type info as (id int, name text);
> creat table test (i info);
> I want to run:
> create index myindex on test (i.id <http://i.id>)
create table test of info primary key(id);
or, if you want to use your type plus other stuff in the table, I
believe its something like...
create table test (i info, stuff...) primary key (i.id)
or
create index test(i.id);
watch out for ambiguity if the type names match the table or field
name. see
http://www.postgresql.org/docs/current/static/rowtypes.html#AEN7836
--
john r pierce, recycling bits in santa cruz