Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] cidr and inet

From: Aaron Holtz <aholtz(at)bright(dot)net>
To: soundar rajan <psrajan(at)yahoo(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] cidr and inet
Date: 1999-10-21 19:25:21
Message-ID: Pine.LNX.4.10.9910211525070.19625-100000@barbarossa.bright.net (view raw or flat)
Thread:
Lists: pgsql-general
Enclose the IP in single quotes.

insert into ip values ('10.20.30.40');

--------------------------------------------------------------------------
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--------------------------------------------------------------------------


On Oct 21, soundar rajan molded the electrons to say....

>Hi all,
>
>I created two tables with CIDR and inet data values
>separately.  I was not able to insert values into it.
>When I tries to do
>
>insert into ip values (10.20.30.40);
>
>the error I get time and again is 
>
>'parser error at or near .30'
>
>It always points to the third part of the IP (ie, 100
>in case of 10.30.100.200)
>
>Any help be appreciated.
>
>Thanks
>
>
>__________________________________________________
>Do You Yahoo!?
>Bid and sell for free at http://auctions.yahoo.com
>
>************
>


In response to

pgsql-general by date

Next:From: Aaron J. SeigoDate: 1999-10-21 19:40:01
Subject: Re: [GENERAL] cidr and inet
Previous:From: soundar rajanDate: 1999-10-21 19:15:03
Subject: cidr and inet

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group