Search Postgresql Archives

Re: Running a PL/pgSQL function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Christophe <xof@xxxxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux