Re: Running a PL/pgSQL function - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Running a PL/pgSQL function
Date
Msg-id dcc563d10808111852t419233b2qe39b2dafa95ded46@mail.gmail.com
Whole thread Raw
In response to Re: Running a PL/pgSQL function  (Adrian Klaver <aklaver@comcast.net>)
List pgsql-general
On Mon, Aug 11, 2008 at 6:03 PM, Adrian Klaver <aklaver@comcast.net> 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!

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Running a PL/pgSQL function
Next
From: erithema
Date:
Subject: problem using a xpath function