Re: Extending Datatype - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: Extending Datatype
Date
Msg-id 200302141238.h1ECcmf02988@candle.pha.pa.us
Whole thread Raw
In response to Re: Extending Datatype  ("Wei Weng" <wweng@kencast.com>)
List pgsql-sql
Well, look in /contrib for some example data types.  The job isn't
trivial.  Can you explain how UNIQUEIDENTIFIER is different from SERIAL?

---------------------------------------------------------------------------

Wei Weng wrote:
> 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
> >
> >
> 
> 

--  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,
Pennsylvania19073
 


pgsql-sql by date:

Previous
From: Gary Stainburn
Date:
Subject: Re: Table Pivot
Next
From: Mintoo Lall
Date:
Subject: Drop temporary table only if it exists