主页 / 问题 / 732358
Accepted
Егор
Asked:2020-10-18 13:47:17 +0000 UTC2020-10-18 13:47:17 +0000 UTC

如何将查询分配给 Postgresql 变量？

  • 772

如何将查询分配给变量？类推如 mssql

@result=Select * from dual where a1=a2;

真实例子

CREATE OR REPLACE FUNCTION table_test ()
 RETURNS varchar(1) AS
$BODY$
 DECLARE
 outinfo varchar(1);
 test text;
 BEGIN
    test = select count(*) from table;
    if test>0 THEN
    outinfo := 'y';
    else
    outinfo := 'n';
    END if;
    return outinfo;
end;
$BODY$
LANGUAGE plpgsql VOLATILE
postgresql

1 个回答

  1. Best Answer

    我会像这样重写你的函数：

    CREATE OR REPLACE FUNCTION stoppagelog2ora () RETURNS BOOLEAN AS $BODY$
    DECLARE
        _count BIGINT = 0;
    BEGIN
        SELECT INTO _count count(*) FROM mssql_startrepltoora;
        RETURN _count > 0;
    END;
$BODY$ LANGUAGE plpgsql
    • 1

相关问题