Postgresql HStore support

is hstore supported? I can't seem to find any documentation from Phalcon about it.



85.4k
edited Oct '14

You can use the database component to access your hstore attributes:

$sql    = "SELECT books->'name' as book FROM books WHERE book->'year'= 2011";
$result = $connection->query($sql);

http://docs.phalconphp.com/en/latest/reference/db.html