real-database icon indicating copy to clipboard operation
real-database copied to clipboard

PostgreSQL arrays

Open taai opened this issue 13 years ago • 2 comments

I hope to see an array support for PostgreSQL. Read more about Arrays here: http://www.postgresql.org/docs/9.1/static/arrays.html

taai avatar May 16 '12 11:05 taai

To define a column as an array, it is sufficient to pass 'integer[]' to DDL_Column::type(). I suppose you'd like an object that converts a PHP array to the PostgreSQL array literal syntax?

e.g. array(1,2,3)'{1,2,3}'

cbandy avatar May 16 '12 12:05 cbandy

Yes, that would be great to just work with automatically converted (vice-versa) arrays, instead of converting them manually. Just consider it. ;)

taai avatar May 16 '12 12:05 taai