Re: [HACKERS] A small type extension example for the contrib directory (fwd) - Mailing list pgsql-hackers

From Peter T Mount
Subject Re: [HACKERS] A small type extension example for the contrib directory (fwd)
Date
Msg-id Pine.LNX.3.95.980125104839.3312A-100000@maidast
Whole thread Raw
In response to A small type extension example for the contrib directory (fwd)  (The Hermit Hacker <scrappy@hub.org>)
Responses Re: [HACKERS] A small type extension example for the contrib directory (fwd)
List pgsql-hackers
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@earthling.net or pmount@maidast.demon.co.uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk


pgsql-hackers by date:

Previous
From: Brett McCormick
Date:
Subject: Re: [HACKERS] A small type extension example for the contrib directory (fwd)
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] fork/exec for backend