我想用c#查看display中表中的数据,但我在postgresql中的函数返回错误:
ERROR: query has no destination for result data
HINT: If you want to discard the results of a SELECT, use PERFORM instead.
CONTEXT: PL/pgSQL function view1() line 3 at SQL statement
SQL state: 42601
postgresql函数:
CREATE OR REPLACE FUNCTION View1 ()
RETURNS table (X varchar,Y varchar,Provinces varchar)
AS
$BODY$
BEGIN
RETURN
( SELECT "X","Y","Provinces" FROM public.point) ;
END;
$BODY$ LANGUAGE plpgsql;
请帮帮我。
暂无答案!
目前还没有任何答案,快来回答吧!