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

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

From: Peter T Mount <psqlhack(at)maidast(dot)demon(dot)co(dot)uk>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] A small type extension example for the contrib directory (fwd)
Date: 1998-01-25 10:51:20
Message-ID: Pine.LNX.3.95.980125104839.3312A-100000@maidast (view raw or flat)
Thread:
Lists: 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(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


In response to

Responses

pgsql-hackers by date

Next:From: Goran ThyniDate: 1998-01-25 11:13:47
Subject: Re: [HACKERS] fork/exec for backend
Previous:From: Tom I HelbekkmoDate: 1998-01-25 09:20:49
Subject: Re: [HACKERS] A small type extension example for the contrib directory (fwd)

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