Re: [SQL] PLpgSQL variables persistance between several functions calls

2011-05-03 Thread Willy-Bas Loos
Hi, Maybe calling a function from within another function would be a solution to you. Cheers, WBL On Tue, May 3, 2011 at 4:10 AM, Pavel Stehule wrote: > Hello > > no, it's not possible > > Regards > > Pavel Stehule > > 2011/5/2 Charles N. Charotti : > > Hello everybody ! > > > > I want to know

[SQL] number of values updated per column

2013-01-17 Thread Willy-Bas Loos
Hi, I'd like to know, per column, how many values were changed by my query. I have a working example, but i am curious what you people think about it. Is it efficient? I have to make a self join, but i don't see a faster way. Here's the example: - drop table if exists tab1 ; create t