empty view, replace view, column type change?

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: PgSQL - SQL <pgsql-sql(at)postgresql(dot)org>
Subject: empty view, replace view, column type change?
Date: 2005-06-23 20:03:29
Message-ID: 1119557009.7430.16.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

it seems to me that the following should work but it fails:

CREATE VIEW co AS SELECT LOCALTIMESTAMP::TIMESTAMP AS ov WHERE FALSE;
CREATE TABLE link (ov TIMESTAMP);
CREATE OR REPLACE VIEW co AS SELECT ov FROM link;

Markus

--
Markus Bertheau <twanger(at)bluetwanger(dot)de>

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Russell Simpkins 2005-06-23 20:03:45 Re: Grouping Too Closely
Previous Message Tom Lane 2005-06-23 19:28:50 Re: optimizer, view, union