Postgres Pro
Downloads
Home   >   mailing lists

empty view, replace view, column type change? - Mailing list pgsql-sql

From Markus Bertheau
Subject empty view, replace view, column type change?
Date
Msg-id 1119557009.7430.16.camel@localhost.localdomain
Whole thread Raw
Responses Re: empty view, replace view, column type change?  (Markus Bertheau <twanger@bluetwanger.de>)
Re: empty view, replace view, column type change?  (Rod Taylor <pg@rbt.ca>)
List pgsql-sql
Tree view 
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@bluetwanger.de>

pgsql-sql by date:

Previous
From: "Russell Simpkins"
Date:
Subject: Re: Grouping Too Closely
Next
From: Markus Bertheau
Date:
Subject: Re: empty view, replace view, column type change?