Re: mac.c - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: mac.c
Date
Msg-id 39A0AEF9.7663FDF@alumni.caltech.edu
Whole thread Raw
In response to mac.c  (Larry Rosenman <ler@lerctr.org>)
List pgsql-hackers
> > o Two new functions, trunc(macaddr) and text(macaddr), where the former
> > returns the mac address with the low (non-manufacturer) fields zeroed
> > out, and the latter converts to a text string. The text conversion is
> > nice because capabilities such as LIKE can be used transparently :) Will
> > need to add macaddr(text) for symmetry.
> A cast shouldn't alter the value of the, er, value. This is like
> text(55) returning 'fifty-five'. What if I want to use substr() on the
> macaddr?

?? Just go ahead and use it! :)

There isn't anything new here, other than having the feature available
for macaddr as it is for other data types.
                     - Thomas


pgsql-hackers by date:

Previous
From: Ned Lilly
Date:
Subject: Re: Bug tracking (was Re: +/- Inf for float8's)
Next
From: Tom Lane
Date:
Subject: BIT/BIT VARYING status