Postgres Pro
Downloads
Home   >   mailing lists

Re: Can CREATE TYPE be used to create a synonym? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Can CREATE TYPE be used to create a synonym?
Date
Msg-id 15372.1202698673@sss.pgh.pa.us
Whole thread Raw
In response to Can CREATE TYPE be used to create a synonym?  ("Dean Gibson (DB Administrator)" <postgresql@ultimeth.com>)
Responses Re: Can CREATE TYPE be used to create a synonym?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
"Dean Gibson (DB Administrator)" <postgresql@ultimeth.com> writes:
> CREATE TYPE DATETIME AS (dummy TIMESTAMP);

> I suspect not (syntax issues w/ input, output, etc).  Is there an 
> alternate way to declare a type synonym?

CREATE DOMAIN would serve a lot better.
        regards, tom lane

pgsql-sql by date:

Previous
From: "Dean Gibson (DB Administrator)"
Date:
Subject: Can CREATE TYPE be used to create a synonym?
Next
From: Tom Lane
Date:
Subject: Re: Can CREATE TYPE be used to create a synonym?