| From: | Tom Jenkins <tjenkins(at)devis(dot)com> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pl/pgsql function not working |
| Date: | 2002-06-19 15:07:30 |
| Message-ID: | 1024499251.711.69.camel@asimov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | BRINER Cedric | 2002-06-19 15:24:14 | Re: compiling problem: tab-complete.c |
| Previous Message | strange | 2002-06-19 15:04:51 | Re: what different beetwen "begin work; " and "begin transaction; " ???? |