On Wed, 2006-11-29 at 14:39 -0600, Dave Bodenstab wrote:
> 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 );
> ERROR: syntax error at or near ")" at character 45
> LINE 1: create unique index x1 on test ( ordinal );
You need more parenthesis.
test=> create unique index x1 on test ( ( ordinal ) );
The reason is because "ordinal" is an expression, similar to "ordinal
 + 5" which would also need parenthesis.
Hope this helps,
In response to
pgsql-general by date
|Next:||From: wheel||Date: 2006-12-01 00:15:40|
|Subject: Restore database from files (not dump files)?|
|Previous:||From: Jim Nasby||Date: 2006-11-30 22:05:45|
|Subject: Re: Blob fields and backups|