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	June 23, 2005 20:03:54
Msg-id	1119557009.7430.16.camel@localhost.localdomain Whole thread Raw
Responses	Re: empty view, replace view, column type change? Re: empty view, replace view, column type change?
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:

From: "Russell Simpkins"
Date: 23 June 2005, 20:03:50
Subject: Re: Grouping Too Closely

From: Markus Bertheau
Date: 23 June 2005, 20:22:12
Subject: Re: empty view, replace view, column type change?

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

Previous

Next