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
