Hello, On Fri, 2016-12-23 at 16:44 +0100, Alessandro Baggi wrote: > Hi list, > sorry for this OT. > > I have a table on postgresql like this: > > id serial not null, > srcaddr varchar(16) not null > > I use this table to store ip address. I've used also inet type but > changed to see if this solves my problem. > > From psql, I run: > > select count(*) from bs_ipsource where srcaddr = '192.168.1.1'; > >
I store and retrieve IP Addresses as follows:- id serial not null, srcaddr inet not null select count(*) from bs_ipsource where srcaddr = '192.168.1.1'::inet; Cast the textual representation to inet. Never had a problem. HTH, Rob -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
