AS t1 (s VARCHAR)
)的情况。
此要求不适用于标量函数。
示例(PostgreSQL):
CREATE FUNCTION produce_a_table() RETURNS RECORD AS $$
SELECT 1;
$$ LANGUAGE sql;
SELECT * FROM produce_a_table() AS s (c1 INT);
SELECT * FROM produce_a_table() AS s (c1);
SELECT * FROM DBLINK('dbname=mydb', 'SELECT proname, prosrc FROM pg_proc') AS t1;
AS s (c1 INT)
具有类型别名,而 AS s (c1)
和 AS t1
没有。
在这种情况下,将高亮显示 produce_a_table()
和 DBLINK()
的第二次调用。