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

From Adrian Klaver
Subject Re: Running a PL/pgSQL function
Date
Msg-id 200808111703.55596.aklaver@comcast.net
Whole thread Raw
In response to Running a PL/pgSQL function  (Christophe <xof@thebuild.com>)
Responses Re: Running a PL/pgSQL function  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
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
(1 row)



--
Adrian Klaver
aklaver@comcast.net

pgsql-general by date:

Previous
From: Klint Gore
Date:
Subject: Re: Can I search for text in a function?
Next
From: Tom Lane
Date:
Subject: Re: Running a PL/pgSQL function