Re: syntax error on Function return setoff

From: Garry Chen <gc92(at)cornell(dot)edu>
To: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>, "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: syntax error on Function return setoff
Date: 2018-01-26 19:01:41
Message-ID: 48FC50A3-2D8C-4F90-99A8-40C6A623740F@cornell.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Here is the short/simple function in postgresql 9.6.

CREATE OR REPLACE FUNCTION public.sec_select_labor_data(
)
RETURNS SETOF acct_nbr_lst
LANGUAGE 'plpgsql'

AS $BODY$
Declare
v_cnt numeric;
sec_role varchar(20);
v_netid varchar(30);
begin

RETURN QUERY Select acct_nbr from kdw_acct_security where lower(netid) = CURRENT_USER;

end;

$BODY$;

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2018-01-27 10:35:05 Re: syntax error on Function return setoff
Previous Message Andreas Kretschmer 2018-01-26 18:54:47 Re: syntax error on Function return setoff