Re: [HACKERS] A small type extension example for the contrib directory (fwd)
James Hughes <jamesh@interpath.com>
From: James Hughes <jamesh@interpath.com>
To: Peter T Mount <psqlhack@maidast.demon.co.uk>
Cc: The Hermit Hacker <scrappy@hub.org>, pgsql-hackers@postgreSQL.org
Date: 1998-01-25T17:11:18Z
Lists: pgsql-hackers
On Sun, 25 Jan 1998, Peter T Mount wrote: > 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. > Hmm... It would be nice to see PgSQL integrated into Scotty/Tkined :) -James