database - PostgreSQL 中的联合

Question

我想实现以下行为 NULL AS(Oracle 数据库):

CREATE OR REPLACE VIEW cuentaahorroview AS
    SELECT IBAN as CCC, Interes, Ultimo_devengo
        FROM De_Ahorro
    UNION
    SELECT CCC, TIPOINTERES as Interes, null as Ultimo_devengo
        FROM CUENTAAHORRO@SCHEMA2BD2;

在 PostgreSQL 数据库中:

CREATE VIEW EditorialView AS
    SELECT * 
        FROM dblink('hostaddr=127.0.0.1 port=5432 dbname=bdp3e1 user=postgres password=1234', 'SELECT * FROM Editorial') 
        AS t1(nombre VARCHAR(100), CIF integer, ubicacion VARCHAR(50))
    UNION
    SELECT *
        FROM dblink('hostaddr=127.0.0.1 port=5432 dbname=bdp3e2 user=postgres password=1234', 'SELECT * FROM Editorial')
        AS t2(nombre VARCHAR(100), CIF integer, NULL);

这样工会才能工作。我该怎么做？

这是我遇到的错误:

psql:PR3_Vistas.sql:10: ERROR:  syntax error at or near "NULL"
LINE 8:   AS t2(nombre VARCHAR(100), CIF integer, NULL);

Answer 1

将 select * 替换为 select field1, field2, ... 并在 union 的第二部分使用 NULL as fieldx。select * 在联合中总是很糟糕 - 您无法确定两个表具有相同的结构。