| From: | Marcin Krawczyk <jankes(dot)mk(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: function call |
| Date: | 2014-08-11 11:13:20 |
| Message-ID: | CABnqL31_H=UkR1gXMMUN8uGuGyzXsBU3mcA7fPjCVT8FMTK-NQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Joseph Krogh | 2014-08-11 16:01:17 | How to optimize WHERE column_a IS NOT NULL OR column_b = 'value' |
| Previous Message | Marcin Krawczyk | 2014-08-11 09:50:19 | Re: function call |