From: Wei Weng <wweng@kencast.com>
To: Guy Fraser <guy@incentre.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: converting microsoft sql server 2000 sql-code for postgresql
Date: Tue, 28 Jan 2003 23:39:47 -0500
Message-ID: <003e01c2c750$74087e60$2f437242@PASCAL> (raw)
References: <000901c2c6b5$2deef350$240aa8c0@L1PC01>
<200301281728.16020.mallah@trade-india.com>
<3E36FCF0.5060305@incentre.net>
<16682.1043805324@sss.pgh.pa.us>
What about a UNIQUEIDENTIFIER type?
Is the only way casting it to a CHAR(38)? (Create a domain for it)
And does the performance suffer if I do the Domain/create my own data type
tricks?
Thanks!
Wei
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Guy Fraser" <guy@incentre.net>
Cc: <pgsql-sql@postgresql.org>
Sent: Tuesday, January 28, 2003 8:55 PM
Subject: Re: [SQL] converting microsoft sql server 2000 sql-code for
postgresql
> Guy Fraser <guy@incentre.net> writes:
> > If you go through the documentation you can also find out how to CREATE
your
> > own data TYPE to allow more direct use of non-PostgreSQL data types.
Here is
> > an example that will allow input of any "datetime" data into PostgreSQL
:
>
> > CREATE TYPE datetime AS (datetime timestamptz);
>
> I think what you probably really want is
>
> CREATE DOMAIN datetime AS timestamptz;
>
> or more SQL-spec-compliantly
>
> CREATE DOMAIN datetime AS timestamp with time zone;
>
> which essentially makes datetime a direct alias for timestamptz. The
> CREATE TYPE approach makes a rowtype containing one timestamptz column,
> which isn't really going to act the way you want --- for one thing,
> none of the predefined functions and operators for type timestamptz
> will accept it. With the DOMAIN approach, they will.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: wweng@kencast.com, guy@incentre.net, tgl@sss.pgh.pa.us
Subject: Re: converting microsoft sql server 2000 sql-code for postgresql
In-Reply-To: <003e01c2c750$74087e60$2f437242@PASCAL>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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