[SQL] empty view, replace view, column type change?

[Markus Bertheau]

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 <[EMAIL PROTECTED]>

signature.asc
Description: This is a digitally signed message part