Re: [BUGS] MACADDR parsing issues

2011-06-06 Thread Matthijs Bomhoff
On Jun 6, 2011, at 4:31 PM, Tom Lane wrote: > Matthijs Bomhoff writes: >> The attached version also rejects MACs containing additional >> whitespace between the octets and separators etc. > > I was under the impression that allowing whitespace there was a feature, > not a bug. Ah, I was not su

Re: [BUGS] MACADDR parsing issues

2011-06-06 Thread Tom Lane
Matthijs Bomhoff writes: > The attached version also rejects MACs containing additional > whitespace between the octets and separators etc. I was under the impression that allowing whitespace there was a feature, not a bug. I'm not sure about the more general question of which abbreviated MAC

[BUGS] MACADDR parsing issues

2011-06-06 Thread Matthijs Bomhoff
Hey, While playing around with different MAC address notations supported by postgresql, I encountered the following: db=> select '08002b-010203'::macaddr; macaddr --- 08:00:2b:01:02:03 (1 row) db=> select '08002b-01023'::macaddr; macaddr --- 08:00: