Re: [GENERAL] cidr and inet

From: "Aaron J(dot) Seigo" <aaron(at)gtv(dot)ca>
To: soundar rajan <psrajan(at)yahoo(dot)com>, pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] cidr and inet
Date: 1999-10-21 19:40:01
Message-ID: 9910211340580A.10632@stilborne
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi...

> insert into ip values (10.20.30.40);
>
> It always points to the third part of the IP (ie, 100
> in case of 10.30.100.200)
>
pgsql is seeing it as a decimal number. enclose it in single quotes and it will
work fine.

insert into ip values ('10.20.30.40');

--
Aaron J. Seigo
Sys Admin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jimmie Houchin 1999-10-21 20:34:15 What's WAL (wasRe: [GENERAL] Postgres INSERTs much slower than MySQL?)
Previous Message Aaron Holtz 1999-10-21 19:25:21 Re: [GENERAL] cidr and inet