array index access outside range

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: array index access outside range
Date: 2008-12-04 15:02:18
Message-ID: 200812041702.19184.achill@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Gary Stainburn 2008-12-04 17:59:48 Re: Trigger/Function - one solution - was constraint question (I think)
Previous Message Gary Stainburn 2008-12-04 10:01:46 constraint question (I think)