postgresql version 7.1.3, compiled with gcc 2.95.2 on solaris 2.6, running
on solaris 2.8.
provisioning=> \d enduser
Table "enduser"
Attribute | Type | Modifier
-----------------+-------------------+----------------------------
account | character varying | not null
active | boolean | not null default 't'::bool
isp_id | integer | not null
speed_plan_id | integer | not null
service_plan_id | integer | not null
node_id | integer | not null
cm_macaddr | macaddr | not null
Indices: enduser_cm_macaddr_key,
enduser_pkey
provisioning=> insert into enduser values ('2', 't', 1, 1, 1, 1, '00:00:00:00:00:00');
INSERT 20853 1
provisioning=> select account,cm_macaddr from enduser where account = '2';
account | cm_macaddr
---------+------------
2 |
(1 row)
provisioning=> select count(*) from enduser where cm_macaddr is null;
count
-------
0
(1 row)
it's not null, so shouldn't it be retrieving as '00:00:00:00:00:00'?
not that i ever expect to encounter that macaddress in the field, but
for consistency's sake...
i just tested 'ff:ff:ff:ff:ff:ff', and it works fine.
ps postgresql sends mysql running back home to mommy. you guys are my heroes.
--
handler@grendel.net (michael handler) washington, dc
