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

2010-11-14 Thread Tom Lane
Peter Eisentraut 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 > string, and

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 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 looke

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

2010-11-14 Thread Tom Lane
Peter Eisentraut 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 was too pla

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: http://

[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 values('fe