Re: procedures and plpgsql PERFORM

2017-12-14 Thread Pavel Stehule
2017-12-15 4:43 GMT+01:00 Ashutosh Bapat : > On Thu, Dec 14, 2017 at 10:16 PM, Pavel Stehule > wrote: > > > > > > 2017-12-14 17:10 GMT+01:00 David G. Johnston >: > >> > >> On Thu, Dec 14, 2017 at 8:22 AM, Merlin Moncure > >> wrote: > >>> > >>> On Thu, Dec 14, 2017 at 8:38 AM, Tom Lane wrote: >

Re: procedures and plpgsql PERFORM

2017-12-14 Thread Ashutosh Bapat
On Thu, Dec 14, 2017 at 10:16 PM, Pavel Stehule wrote: > > > 2017-12-14 17:10 GMT+01:00 David G. Johnston : >> >> On Thu, Dec 14, 2017 at 8:22 AM, Merlin Moncure >> wrote: >>> >>> On Thu, Dec 14, 2017 at 8:38 AM, Tom Lane wrote: >>> > Ashutosh Bapat writes: >>> >> We allow a function to be invo

Re: procedures and plpgsql PERFORM

2017-12-14 Thread Ashutosh Bapat
On Thu, Dec 14, 2017 at 9:40 PM, David G. Johnston wrote: > On Thu, Dec 14, 2017 at 8:22 AM, Merlin Moncure wrote: >> >> On Thu, Dec 14, 2017 at 8:38 AM, Tom Lane wrote: >> > Ashutosh Bapat writes: >> >> We allow a function to be invoked as part of PERFORM statement in >> >> plpgsql >> >> ... >

Re: procedures and plpgsql PERFORM

2017-12-14 Thread Ashutosh Bapat
On Thu, Dec 14, 2017 at 8:08 PM, Tom Lane wrote: > Ashutosh Bapat writes: >> We allow a function to be invoked as part of PERFORM statement in plpgsql >> ... >> But we do not allow a procedure to be invoked this way > >> Procedures fit that category and like functions, I think, we should >> allow

Re: procedures and plpgsql PERFORM

2017-12-14 Thread Merlin Moncure
On Thu, Dec 14, 2017 at 11:56 AM, Pavel Stehule wrote: > > > 2017-12-14 18:33 GMT+01:00 Merlin Moncure : >> >> On Thu, Dec 14, 2017 at 10:46 AM, Pavel Stehule >> wrote: >> > >> > >> > 2017-12-14 17:10 GMT+01:00 David G. Johnston >> > : >> >> >> >> On Thu, Dec 14, 2017 at 8:22 AM, Merlin Moncure

Re: procedures and plpgsql PERFORM

2017-12-14 Thread Pavel Stehule
2017-12-14 18:33 GMT+01:00 Merlin Moncure : > On Thu, Dec 14, 2017 at 10:46 AM, Pavel Stehule > wrote: > > > > > > 2017-12-14 17:10 GMT+01:00 David G. Johnston >: > >> > >> On Thu, Dec 14, 2017 at 8:22 AM, Merlin Moncure > >> wrote: > >>> > >>> On Thu, Dec 14, 2017 at 8:38 AM, Tom Lane wrote:

Re: procedures and plpgsql PERFORM

2017-12-14 Thread Merlin Moncure
On Thu, Dec 14, 2017 at 10:46 AM, Pavel Stehule wrote: > > > 2017-12-14 17:10 GMT+01:00 David G. Johnston : >> >> On Thu, Dec 14, 2017 at 8:22 AM, Merlin Moncure >> wrote: >>> >>> On Thu, Dec 14, 2017 at 8:38 AM, Tom Lane wrote: >>> > Ashutosh Bapat writes: >>> >> We allow a function to be invo

Re: procedures and plpgsql PERFORM

2017-12-14 Thread Pavel Stehule
2017-12-14 17:10 GMT+01:00 David G. Johnston : > On Thu, Dec 14, 2017 at 8:22 AM, Merlin Moncure > wrote: > >> On Thu, Dec 14, 2017 at 8:38 AM, Tom Lane wrote: >> > Ashutosh Bapat writes: >> >> We allow a function to be invoked as part of PERFORM statement in >> plpgsql >> >> ... >> >> But we d

Re: procedures and plpgsql PERFORM

2017-12-14 Thread David G. Johnston
On Thu, Dec 14, 2017 at 8:22 AM, Merlin Moncure wrote: > On Thu, Dec 14, 2017 at 8:38 AM, Tom Lane wrote: > > Ashutosh Bapat writes: > >> We allow a function to be invoked as part of PERFORM statement in > plpgsql > >> ... > >> But we do not allow a procedure to be invoked this way > > > >> Pro

Re: procedures and plpgsql PERFORM

2017-12-14 Thread Merlin Moncure
On Thu, Dec 14, 2017 at 8:38 AM, Tom Lane wrote: > Ashutosh Bapat writes: >> We allow a function to be invoked as part of PERFORM statement in plpgsql >> ... >> But we do not allow a procedure to be invoked this way > >> Procedures fit that category and like functions, I think, we should >> allow

Re: procedures and plpgsql PERFORM

2017-12-14 Thread Tom Lane
Ashutosh Bapat writes: > We allow a function to be invoked as part of PERFORM statement in plpgsql > ... > But we do not allow a procedure to be invoked this way > Procedures fit that category and like functions, I think, we should > allow them be invoked directly without any quoting and CALL > d

Re: procedures and plpgsql PERFORM

2017-12-14 Thread Merlin Moncure
On Thursday, December 14, 2017, Ashutosh Bapat < ashutosh.ba...@enterprisedb.com> wrote: > Hi, > We allow a function to be invoked as part of PERFORM statement in plpgsql > do $$ > begin perform pg_relation_size('t1'); end; $$ language plpgsql; > DO > > But we do not allow a procedure to be invoke

Re: procedures and plpgsql PERFORM

2017-12-14 Thread Pavel Stehule
2017-12-14 8:21 GMT+01:00 Ashutosh Bapat : > Hi, > We allow a function to be invoked as part of PERFORM statement in plpgsql > do $$ > begin perform pg_relation_size('t1'); end; $$ language plpgsql; > DO > > But we do not allow a procedure to be invoked this way > create procedure dummy_proc(a in

procedures and plpgsql PERFORM

2017-12-13 Thread Ashutosh Bapat
Hi, We allow a function to be invoked as part of PERFORM statement in plpgsql do $$ begin perform pg_relation_size('t1'); end; $$ language plpgsql; DO But we do not allow a procedure to be invoked this way create procedure dummy_proc(a int) as $$ begin null; end; $$ language plpgsql; CREATE PROCE