Skip site navigation (1) Skip section navigation (2)

MACADDR type & 00:00:00:00:00:00

From: Michael Handler <handler(at)grendel(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: MACADDR type & 00:00:00:00:00:00
Date: 2002-01-07 20:30:26
Message-ID: 20020107153026.D12847@monster.grendel.net (view raw or flat)
Thread:
Lists: pgsql-bugs
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(at)grendel(dot)net (michael handler)                           washington, dc

pgsql-bugs by date

Next:From: Wolfgang FuertbauerDate: 2002-01-08 09:24:57
Subject: Problem with ODBC Driver Version 7.1.9, DB Version 7.1.3
Previous:From: Bruce MomjianDate: 2002-01-06 18:11:38
Subject: Re: ECPG bug in --help

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group