array index access outside range - Mailing list pgsql-sql

From Achilleas Mantzios
Subject array index access outside range
Date
Msg-id 200812041702.19184.achill@matrix.gatewaynet.com
Whole thread Raw
List pgsql-sql
Hello list,
Let's suppose that we have an inteher array "parents"
select parents from machdefs where defid=888;
{1,2,3}
Currently accessing parents[0] returns a null, which is reasonable,
and i am thinking of relying on this assumption.

The question is, will it be safe to do that?
Is there any thoughts/needs/discussions of changing this behaviour in a future version
thus breaking my program?

Thanx a lot
-- 
Achilleas Mantzios


pgsql-sql by date:

Previous
From: Gary Stainburn
Date:
Subject: constraint question (I think)
Next
From: Gary Stainburn
Date:
Subject: Re: Trigger/Function - one solution - was constraint question (I think)