# Postgres inet operators for query filter

**URL:** <https://community.dreamfactory.com/t/postgres-inet-operators-for-query-filter/1556>\
**Category:** REST API\
**Created:** [October 1, 2015, 3:22pm UTC](https://community.dreamfactory.com/t/postgres-inet-operators-for-query-filter/1556 "2015-10-01T15:22:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![netviz](https://avatars.discourse-cdn.com/v4/letter/n/c4cdca/32.png) [@netviz](https://community.dreamfactory.com/u/netviz)\
**Post date:** [October 1, 2015, 3:22pm UTC](https://community.dreamfactory.com/t/postgres-inet-operators-for-query-filter/1556/1 "2015-10-01T15:22:05Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![jeffreystables](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/jeffreystables/32/173_2.png) [@jeffreystables](https://community.dreamfactory.com/u/jeffreystables)\
**Post date:** [November 3, 2015, 8:56pm UTC](https://community.dreamfactory.com/t/postgres-inet-operators-for-query-filter/1556/2 "2015-11-03T20:56:03Z")

</div>

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