On Mon, Aug 11, 2008 at 6:03 PM, Adrian Klaver <aklaver@xxxxxxxxxxx> 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 database. The correct way of invoking this >> function is: >> >> SELECT my_func(); >> >> ... yes? Thanks; it seems to work fine, but using SELECT here is >> causing some part of my brain to scream "counter-intuitive." > > Similar to doing: > > test=# SELECT 1+1; > ?column? > ---------- > 2 Hey, it beats select 1+1 from dual!