Re: [GENERAL] Running a PL/pgSQL function

2008-08-11 Thread Scott Marlowe
On Mon, Aug 11, 2008 at 6:03 PM, Adrian Klaver <[EMAIL PROTECTED]> wrote: > On Monday 11 August 2008 4:24:17 pm Christophe wrote: >> I'm startled that I've never done this before, but... I have a PL/ >> pgSQL function that takes no arguments, returns VOID, and has a bunch >> of side effects on the

Re: [GENERAL] Running a PL/pgSQL function

2008-08-11 Thread Tom Lane
Christophe <[EMAIL PROTECTED]> writes: > I'm startled that I've never done this before, but... I have a PL/ > pgSQL function that takes no arguments, returns VOID, and has a bunch > of side effects on the database. The correct way of invoking this > function is: > SELECT my_func(); > .

Re: [GENERAL] Running a PL/pgSQL function

2008-08-11 Thread Adrian Klaver
On Monday 11 August 2008 4:24:17 pm Christophe wrote: > I'm startled that I've never done this before, but... I have a PL/ > pgSQL function that takes no arguments, returns VOID, and has a bunch > of side effects on the database. The correct way of invoking this > function is: > > SELECT my

[GENERAL] Running a PL/pgSQL function

2008-08-11 Thread Christophe
I'm startled that I've never done this before, but... I have a PL/ pgSQL function that takes no arguments, returns VOID, and has a bunch of side effects on the database. The correct way of invoking this function is: SELECT my_func(); ... yes? Thanks; it seems to work fine, but us