[SQL] Can CREATE TYPE be used to create a synonym?

2008-02-10 Thread Dean Gibson (DB Administrator)
Eg: 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? -- Dean ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [SQL] Can CREATE TYPE be used to create a synonym?

2008-02-10 Thread Tom Lane
BTW, bouncing mail sent to your advertised reply address is a good way to discourage people from ever answering you again. regards, tom lane --- Forwarded Message Return-Path: MAILER-DAEMON Delivery-Date: Sun Feb 10 21:57:56 2008 Received: from localhost (localhost)

Re: [SQL] Can CREATE TYPE be used to create a synonym?

2008-02-10 Thread Tom Lane
"Dean Gibson (DB Administrator)" <[EMAIL PROTECTED]> 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 l

Re: [SQL] Bouncing replies

2008-02-10 Thread Dean Gibson (DB Administrator)
I'm open to suggestions. I've been a member of this list for several years, but every time I post here, some scumbag harvests my eMail address from it and I get hundreds of spam (most gets filtered by postfix). I've gone through a half-dozen eMail addresses on this list alone, and it's been a