Received: from esdi.testengeer.com (root@esdi.testengeer.com [207.243.122.10])
	by hub.org (8.9.2/8.9.1) with ESMTP id KAA13414
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 13 Apr 1999 10:48:22 -0400 (EDT)
	(envelope-from rexb@testengeer.com)
Received: from testengeer.com ([207.243.122.14])
	by esdi.testengeer.com (8.9.3/8.9.0) with ESMTP id KAA29225
	for <pgsql-interfaces@postgreSQL.org>; Tue, 13 Apr 1999 10:29:40 -0500
Sender: root@esdi.testengeer.com
Message-ID: <37135900.A54047B3@testengeer.com>
Date: Tue, 13 Apr 1999 09:47:28 -0500
From: Rex Byrns <rexb@testengeer.com>
Organization: Testengeer, Inc.
X-Mailer: Mozilla 4.08 [en] (X11; I; Linux 2.0.36 i586)
MIME-Version: 1.0
To: "pgsql-interfaces@postgreSQL.org" <pgsql-interfaces@postgreSQL.org>
Subject: Auto incrementing Field
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I have been porting some scripts that were written for mySQL and there
is extensive use of an autoincrementing field.  I gather that I must
write a function to do this.  Anyone have an example or better method?

Another question I have is about the timespan data type.  I am in need
of a way to allow users to enter time worked on specific jobs in the
form of say 8 am thru 12:30 pm  (Date inclusion is ok).  I would like to
prevent overlapping time entries.  The term timespan sounds like it
might be useful for this .

thanks for any help you might give,

    Rex Byrns.