Re: [HACKERS] A small type extension example for the contrib directory (fwd)

On Sun, 25 Jan 1998, The Hermit Hacker wrote:

> I added this to the contrib directory for the server, but am
> wondering if anyone feels that this just might be useful as a "normal"
> datatype, instead of just in the contrib directory...

Personally, I would, as at work, I have a database that contains all of
our machines on the network. It's a real pain handling IP & MAC addresses
as strings.

The IP type would be more useful, as I'd thought that people would use it
in things like web useage logs, etc.

> | PostgreSQL type extensions for IP and MAC addresses.
> |
> | I needed to record IP and MAC level ethernet addresses in a data
> | base, and I really didn't want to store them as plain strings, with
> | no enforced error checking, so I put together the accompanying code
> | as my first experiment with adding a data type to PostgreSQL. I
> | then thought that this might be useful to others, both directly and
> | as a very simple example of how to do this sort of thing, so here
> | it is, in the hope that it will be useful.

--
Peter T Mount petermount(at)earthling(dot)net or pmount(at)maidast(dot)demon(dot)co(dot)uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter(at)maidstone(dot)gov(dot)uk