Postgres inet operators for query filter


#1

Hello,

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 >> ‘128.0.0.2’; --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?


#2

Is the inet type ANSI compliant? Currently for standardization we only support ANSI.