Re: Run Stored procedure - function from VBA - Mailing list pgsql-general

On Jun 18, 2018, at 9:47 AM, Łukasz Jarych <jaryszek@gmail.com> wrote:

CREATE OR REPLACE FUNCTION totalRecords ()

RETURNS integer AS $total$

declare

total integer;

BEGIN

   SELECT count(*) into total FROM COMPANY;

   RETURN total;

END;

$total$ LANGUAGE plpgsql;