Re: [GENERAL] cidr and inet - Mailing list pgsql-general

From Aaron J. Seigo
Subject Re: [GENERAL] cidr and inet
Date
Msg-id 9910211340580A.10632@stilborne
Whole thread Raw
In response to cidr and inet  (soundar rajan <psrajan@yahoo.com>)
List 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

pgsql-general by date:

Previous
From: "amy cheng"
Date:
Subject: Re: [GENERAL] cidr and inet
Next
From: Jimmie Houchin
Date:
Subject: What's WAL (wasRe: [GENERAL] Postgres INSERTs much slower than MySQL?)