Postgre Array

[doublehelix]

I've got items stored in a Postgre array field. Is there any simple way of getting to the array elements?

[bork]

Hello

Currently we don't support working with array fields directly. You can use the following query to get array values:

select MyArray[1], MyArray[2], MyArray[3]
from MyTable

Or you may retrieve all the array values as string:

begin
ShowMessage(PgQuery1.FieldByName('MyArray').AsString);
end;