array faults?

From: David Helgason <david(at)uti(dot)is>
To: pgsql-general(at)postgresql(dot)org
Subject: array faults?
Date: 2004-01-09 14:11:50
Message-ID: C47AA9CE-42AD-11D8-9789-000A9566DA8A@uti.is
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Using arrays I came across some strangenesses. Probably this is well
known, but I couldn't find mentions of it.

I am under the impression that this should be an error. Am I wrong?

EXAMPLE 1:
maint=# select ('{{1,2,3},{4,5,6}}'::int[])[1][1:3];
int4
-----------
{{1,2,3}}
(1 row)

Shouldn't this have been just {1,2,3} ?

EXAMPLE 2:
maint=# select ('{{1,2,3},{4,5,6}}'::int[])[2][1:3];
int4
-----------
{{1,2,3},{4,5,6}}
(1 row)

Shouldn't this have been just {4,5,6} (or maybe {{4,5,6}} accepting the
result of example 1) ?

I am trying to do sth like:
maint=# select 1 = any ('{{1,2,3},{4,5,6}}'::int[])[2][1:3];
But that is not working for obvious reasons. This makes arrays pretty
broken for me.

Am I missing anything obvious?

Regards,

David Helgason
Over the Edge Entertainments

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Janssen 2004-01-09 14:34:49 Re: Optimize query: time of "single * IN(many)" > time of "many *
Previous Message Gerwin Philippo 2004-01-09 14:07:02 Trouble with MsAccess and records above 13000