ipv4 data type does not allow to use % as subnet mask delimiter

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "PostgreSQL - General" <pgsql-general(at)postgresql(dot)org>
Subject: ipv4 data type does not allow to use % as subnet mask delimiter
Date: 2010-11-11 18:33:44
Message-ID: 960CD2C7554B435BB4AA42232BBE75DD@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Windows uses % as subnet mask delimiter.

Trying to use it like

create temp table test (test inet) on commit drop;
insert into test values('fe80::f1ea:f3f4:fb48:7155%10')

returns error

ERROR: invalid input syntax for type inet: "fe80::f1ea:f3f4:fb48:7155%10"
LINE 2: insert into test values('fe80::f1ea:f3f4:fb48:7155%10')

How to fix ?

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Mamin 2010-11-11 19:45:45 Re: Schema tool
Previous Message Guillaume Lelarge 2010-11-11 18:18:04 Re: Schema tool