ipv4 data type does not allow to use % as subnet mask delimiter - Mailing list pgsql-general

From Andrus
Subject ipv4 data type does not allow to use % as subnet mask delimiter
Date
Msg-id 960CD2C7554B435BB4AA42232BBE75DD@andrusnotebook
Whole thread Raw
Responses Re: ipv4 data type does not allow to use % as subnet mask delimiter
List 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.

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Schema tool
Next
From: "Marc Mamin"
Date:
Subject: Re: Schema tool