Create index on array element?

From: Dave Bodenstab <dave_bodenstab(at)sbcglobal(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Create index on array element?
Date: 2006-11-29 20:39:01
Message-ID: ekkr57$19ss$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I guess one cannot create an index on an element of an array?

test=> create table test ( ordinal int[] );
CREATE TABLE
test=> create unique index x1 on test ( ordinal[1] );
ERROR: syntax error at or near ")" at character 45
LINE 1: create unique index x1 on test ( ordinal[1] );
^

Correct, or is my syntax wrong?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2006-11-29 20:40:59 Re: Postgresql data integrity during RAID10 drive rebuild
Previous Message Mark Jensen 2006-11-29 20:19:48 Re: How to implement backup protocol