Re: Running a PL/pgSQL function

Christophe <xof(at)thebuild(dot)com> 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? Thanks; it seems to work fine, but using SELECT here is
> causing some part of my brain to scream "counter-intuitive."

Yeah, it is a little weird but it works fine. We treat VOID as a
more-or-less-real datatype that has only one value, an empty string...

regards, tom lane