Re: pl/pgsql function not working

On Wed, 2002-06-19 at 10:09, Richard Huxton wrote:
> On Wednesday 19 Jun 2002 2:25 pm, Tom Jenkins wrote:
> > hello all,
> > i hope somebody can shed some light on a problem i'm having with
> > pl/pgsql.
>
> >     PERFORM ''update % set lastaccess = NULL;'', obj.relname  ;
>
> Are you sure this shouldn't be EXECUTE (build the sql-string normally first)
>

hrmmm.. replacing PERFORM with EXECUTE results in an error

NOTICE:  Error occurred while executing PL/pgSQL function
clear_lastaccess
NOTICE:  line 6 at execute statement
ERROR:  query "SELECT  'update % set lastaccess = NULL;',  $1 " returned
2 columns




--

Tom Jenkins
Development InfoStructure
http://www.devis.com