Postgres Pro
Downloads
Home   >   mailing lists

Re: pl/pgsql function not working - Mailing list pgsql-general

From Richard Huxton
Subject Re: pl/pgsql function not working
Date
Msg-id 200206191509.04984.dev@archonet.com
Whole thread Raw
In response to pl/pgsql function not working  (Tom Jenkins <tjenkins@devis.com>)
Responses Re: pl/pgsql function not working  (Tom Jenkins <tjenkins@devis.com>)
Re: pl/pgsql function not working  (Darren Ferguson <darren@crystalballinc.com>)
List pgsql-general
Tree view 
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)

- Richard Huxton

pgsql-general by date:

Previous
From: Shaun Thomas
Date:
Subject: Re: Highly obscure and erratic
Next
From: Shaun Thomas
Date:
Subject: Re: Highly obscure and erratic