I am trying to run a a query against a postgres DB that is setup as a service on dreamfactory. I am getting an error when I try to use postgres inet operators as part of filter.
An example pg query is:
select * from networks where network.ip_last >> ‘18.104.22.168’; --this finds an IP within network address space.
Using the >> postgres inet operator in the filter yields
CDbCommand failed to execute the SQL statement: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type inet: ""
Is there a way special way to include this operator in the filter field of a getRecords() call?