Re: [GENERAL] ipv4 data type does not allow to use % as subnet mask delimiter

2010-11-14 Thread Peter Eisentraut
On tor, 2010-11-11 at 20:33 +0200, Andrus wrote: Windows uses % as subnet mask delimiter. This is not a subnet mask but a zone index, but it should probably still be supported. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] ipv4 data type does not allow to use % as subnet mask delimiter

2010-11-14 Thread Tom Lane
Peter Eisentraut pete...@gmx.net writes: On tor, 2010-11-11 at 20:33 +0200, Andrus wrote: Windows uses % as subnet mask delimiter. This is not a subnet mask but a zone index, but it should probably still be supported. I believe we looked into that some time ago and decided that the behavior

Re: [GENERAL] ipv4 data type does not allow to use % as subnet mask delimiter

2010-11-14 Thread Peter Eisentraut
On sön, 2010-11-14 at 16:46 -0500, Tom Lane wrote: Peter Eisentraut pete...@gmx.net writes: On tor, 2010-11-11 at 20:33 +0200, Andrus wrote: Windows uses % as subnet mask delimiter. This is not a subnet mask but a zone index, but it should probably still be supported. I believe we

Re: [GENERAL] ipv4 data type does not allow to use % as subnet mask delimiter

2010-11-14 Thread Tom Lane
Peter Eisentraut pete...@gmx.net writes: On sön, 2010-11-14 at 16:46 -0500, Tom Lane wrote: I believe we looked into that some time ago and decided that the behavior was too platform-dependent to be worth messing with. I suppose the problem is that the zone identifier could be almost any

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

2010-11-11 Thread Andrus
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