X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id DAF64474E4F
	for <pgsql-sql@postgresql.org>; Fri, 14 Feb 2003 00:51:44 -0500 (EST)
Received: from mail1.acecape.com (mail1.acecape.com [66.114.74.12])
	by postgresql.org (Postfix) with ESMTP id 4EABF474E42
	for <pgsql-sql@postgresql.org>; Fri, 14 Feb 2003 00:51:44 -0500 (EST)
Received: from PASCAL (p67-47.acedsl.com [66.114.67.47])
	by mail1.acecape.com (8.12.2/8.12.2) with SMTP id h1E5pZwo008621;
	Fri, 14 Feb 2003 00:51:36 -0500
Message-ID: <001101c2d3ed$49ca74b0$2f437242@PASCAL>
Reply-To: "Wei Weng" <wengwei@alumni.stevens-tech.edu>
From: "Wei Weng" <wweng@kencast.com>
To: "Bruce Momjian" <pgman@candle.pha.pa.us>
Cc: <pgsql-sql@postgresql.org>
References: <200302132306.h1DN6Rt27252@candle.pha.pa.us>
Subject: Re: Extending Datatype
Date: Fri, 14 Feb 2003 00:52:41 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/318
X-Sequence-Number: 11716

I need to use the UNIQUEIDENTIFIER. There are other concerns in the database
design that makes using a serial type very inpractical.

Is there easy example of writing a data type extension somewhere??

Thanks


Wei

----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Wei Weng" <wweng@kencast.com>
Cc: <pgsql-sql@postgresql.org>
Sent: Thursday, February 13, 2003 6:06 PM
Subject: Re: [SQL] Extending Datatype


>
> Try the SERIAL data type.  It uses sequences and DEFAULT.  Read the FAQ.
>
> --------------------------------------------------------------------------
-
>
> Wei Weng wrote:
> > Where can I find a more detailed doc on how to write module for extended
> > datatype? There isn't much about it on techdoc.postgresql.org.
> >
> > (I need to write one for UNIQUEIDENTIFIER.)
> >
> > Thanks!
> >
> >
> > Wei
> >
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
> >
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square, Pennsylvania
19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>