Windows DatabaseebooksStatistical Information

LLE10225 : Howto execute a newly created function in postgres

Symptom:

You just created a new function and want to execute it but postgresql delivers an error <function name> does not exist

Cause:

none

Solution:

You probably used the execute command followed by your functionname to execute your function. This does not work. To execute a function you use the select command. e.g.

select my_functionname(myparameters);

This will do the job.

Disclaimer:

The information provided in this document is intended for your information only. Lubby makes no claims to the validity of this information. Use of this information is at own risk!
Copyright © 2004-2011 Lubby (V3.0.10 Aug 2011)
Sponsored by Keskon.
Statistical information by Google Analytics