Re: function call - Mailing list pgsql-sql

From Marcin Krawczyk
Subject Re: function call
Date
Msg-id CABnqL31_H=UkR1gXMMUN8uGuGyzXsBU3mcA7fPjCVT8FMTK-NQ@mail.gmail.com
Whole thread Raw
In response to Re: function call  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: function call  (David G Johnston <david.g.johnston@gmail.com>)
List pgsql-sql
So it would seem that the issue is with ERP application returning the information.

This probably hinges on what you are defining as returning?

In your function description you note that the function issues documents.

Is that what you are using to determine that the function has completed?

The function makes some calculations, then INSERTs and UPDATEs data (the aforementioned documents) then returns 1 row with 3 columns with information on whether there were any errors or how many documents were created and so on.

 

pgsql-sql by date:

Previous
From: Marcin Krawczyk
Date:
Subject: Re: function call
Next
From: Tom Lane
Date:
Subject: Re: Update Returning as subquery