[GENERAL] Create index on array element?

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] );

Re: [GENERAL] Create index on array element?

Jeff Davis wrote: 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[1] ); ERROR: syntax error at or near

[GENERAL] My problem upgrading to 8.0.0

e up back when the array output was changed. I could not find any reference on Google or postgresql.org but I probably am not phrasing my queries well enough. If this was an issue when array output changed, can anyone point me at some possible solutions that hopefully don't requi

[GENERAL] Is news.postgresql.org still alive?

use some other server or some other port? Is the news access still open to the public? Thanks. Dave Bodenstab ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHer