[DBAL-116] Support Array type For Postgresql Created: 29/Apr/11  Updated: 05/Aug/13  Resolved: 30/Apr/11

Status: Resolved
Project: Doctrine DBAL
Component/s: Drivers
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Minor
Reporter: Brice Maron Assignee: Benjamin Eberlei
Resolution: Won't Fix Votes: 0
Labels: None
Environment:

Postgresql >= 8.4



 Description   

Hi,

Since at least postgres 8.4 , pg support arrays...
it could be nice if doctrine could read them as a type instead of use a string for it.
Postgresql also offer a sort of hash array named hstore...

Thanks

http://www.postgresql.org/docs/8.4/static/arrays.html

http://www.postgresql.org/docs/8.4/static/hstore.html



 Comments   
Comment by Benjamin Eberlei [ 30/Apr/11 ]

This will not be implemented as it is implementation specific whereas Doctrine features need to be supported by all vendors.

You can already implement this with custom types though, i remember testing this some time ago.

Comment by Karsten Dambekalns [ 19/Oct/12 ]

Why is this not to be implemented? It can be used by the PostgreSQL driver without anything above it needing change - all platform drivers exist precisely to deal with implementation specifics… No?

Comment by Karsten Dambekalns [ 05/Aug/13 ]

Coming back to this and still wonder why it cannot be implemented. Could even be a solution / combined with DBAL-369

Comment by Benjamin Eberlei [ 05/Aug/13 ]

See https://github.com/easybiblabs/EasyBib_DoctrineTypes for an implementation of PostgreSQL Hstore. Arrays can be implemented the same way.

Generated at Sat Oct 25 08:54:14 UTC 2014 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.