pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedExtending Datatype
4+ messages / 2 participants
[nested] [flat]
* Extending Datatype
@ 2003-02-13 21:54 Wei Weng <wweng@kencast.com>
0 siblings, 1 reply; 4+ messages in thread
From: Wei Weng @ 2003-02-13 21:54 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Extending Datatype
@ 2003-02-13 23:06 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Wei Weng <wweng@kencast.com>
0 siblings, 1 reply; 4+ messages in thread
From: Bruce Momjian @ 2003-02-13 23:06 UTC (permalink / raw)
To: Wei Weng <wweng@kencast.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Extending Datatype
@ 2003-02-14 05:52 Wei Weng <wweng@kencast.com>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Wei Weng @ 2003-02-14 05:52 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: pgsql-sql
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
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Extending Datatype
@ 2003-02-14 12:38 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Wei Weng <wweng@kencast.com>
0 siblings, 0 replies; 4+ messages in thread
From: Bruce Momjian @ 2003-02-14 12:38 UTC (permalink / raw)
To: Wei Weng <wengwei@alumni.stevens-tech.edu>; +Cc: 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, Pennsylvania 19073
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-02-14 12:38 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-13 21:54 Extending Datatype Wei Weng <wweng@kencast.com>
2003-02-13 23:06 ` Bruce Momjian <pgman@candle.pha.pa.us>
2003-02-14 05:52 ` Wei Weng <wweng@kencast.com>
2003-02-14 12:38 ` Bruce Momjian <pgman@candle.pha.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox