Re: Run Stored procedure - function from VBA

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Łukasz Jarych <jaryszek(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Run Stored procedure - function from VBA
Date: 2018-06-18 23:33:03
Message-ID: 445C3ADF-ECBA-4D70-9FE2-5ED62343DAF4@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Jun 18, 2018, at 9:47 AM, Łukasz Jarych <jaryszek(at)gmail(dot)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;

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2018-06-18 23:34:04 Re: Run Stored procedure - function from VBA
Previous Message Robert Creager 2018-06-18 22:33:54 Re: Query hitting empty tables taking 48 minutes