search

cbandy / real-database

Kohana Database rewrite with emphasis on query building
28 stars 0 forks source link

PostgreSQL arrays #9

Open taai opened 12 years ago

taai commented 12 years ago

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

cbandy commented 12 years ago

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}'

taai commented 12 years ago

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