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

["Andrus" <kobruleht2@xxxxxx>]

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.

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general