Using Postgresql 9.4
I have a table with a hstore field named 'references' :
Trying to do : select * from table where (references -> 'key' = 'value') results in
ERROR: syntax error at or near "references"
As it works as expected with another fieldname, I suspect it's because it's a reserved word... but I don't feel like renaming this heavily used field in my application.
So, is there any syntax to work around this problem ?
So, thanks to David, the solution is :
select * from table where ( "references"->'key' = 'value' );
where the meaning of quotes and double-quotes is important.