Thread: Extending Datatype

Extending Datatype

From
Wei Weng
Date:
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






Re: Extending Datatype

From
Bruce Momjian
Date:
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,
Pennsylvania19073
 


Re: Extending Datatype

From
"Wei Weng"
Date:
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
>
>



Re: Extending Datatype

From
Bruce Momjian
Date:
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