Postgres Pro
Downloads
Home   >   mailing lists

Re: Any reasons for 'DO' statement not returning result? - Mailing list pgsql-general

From Chris Travers
Subject Re: Any reasons for 'DO' statement not returning result?
Date
Msg-id CAKt_ZftVKBHRRG+RN8v49k+Qdk4XnYf-nC_ze-NOFUiL=O8QrA@mail.gmail.com
Whole thread Raw
In response to Re: Any reasons for 'DO' statement not returning result?  (Xtra Coder <xtracoder@gmail.com>)
Responses Re: Any reasons for 'DO' statement not returning result?
List pgsql-general
Tree view
If all you want is a temporary function, you *can* create it in the pg_temp namespace though that seems hackish.

Maybe a better solution would be to extend CREATE FUNCTION in a way that allows you to CREATE TEMPORARY FUNCTION?

On Sun, Aug 14, 2016 at 9:28 AM, Xtra Coder <xtracoder@gmail.com> wrote:
Thanks for the link. After looking through it i see following major points:

- thread is from 2013 and nothing changed today in 2016
- quote from that thread (C) Dimitri Fontaine
   "That topic apparently raises each year and rehash the same points"
   (So ... there should be more similar discussions in previous years, i.e. topic was first stated more than 3 years ago)
- most people agree that DO somehow needs to be made 'RETURNING', but there is no consensus how this should be made

And out of that I feel there is no luck with that feature in foreseeable future :(. 




--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.

pgsql-general by date:

Previous
From: Xtra Coder
Date:
Subject: Re: Any reasons for 'DO' statement not returning result?
Next
From: Xtra Coder
Date:
Subject: Re: Any reasons for 'DO' statement not returning result?