On Fri, Apr 27, 2012 at 2:43 PM, J.V. <jvsrvcs@xxxxxxxxx> wrote: > I have created a stored function and wish to execute in pgadmin but keep > getting an error. > > create or replace function myfunc() returns boolean > as $$ > declare > begin > ... > end; > $$ language plpgsql; > > compiles and works just find, however when I run (in pgadmin III) > > select myfunc(); > > I get errors telling me I need to use 'perform' instead, but when I run: that error is being thrown from indie the function. somewhere inside the function body you are using select where you should be using perform. > perform myfunc(); it says : syntax error at or near "perform" > LINE 1: perform myfunc(); perform only makes sense inside functions. it has not meaning except inside sql. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
