[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

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

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(); ... yes?

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