Subject Re: [firebird-support] How work with Arrays in Firebird ?
Author Ivan Prenosil
> I am try to work with array, what I need to do ?
>
> I create a test table with field: qtd_day integer[1:365]
>
> And try insert like: insert into table value (123[1]) <<<< ?
> or perhaps: insert into table value (123(44)) <<<< ?
>
> but dont work ...
>
> May I work with Arrays field in Stored Procedure, Triggers or not ?
>
> What I need to do ?

The *only* operation on arrays supported in sql (and in SP/triggers)
is retrieving individual value, e.g.

SELECT qtd_day[30]
FROM tab
WHERE qtd_day[1]=1000;

All other functionality is accessible via specialized API *only*.

Internally, arrays are just specialized blobs. So if you use blobs
instead of arrays you will loose the ability to directly retrieve
single values in sql, but you will get better support from other
tools and libraries.

Ivan
http://www.volny.cz/iprenosil/interbase/