Re: pl/pgsql function not working

From: Richard Huxton <dev(at)archonet(dot)com>
To: Tom Jenkins <tjenkins(at)devis(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: pl/pgsql function not working
Date: 2002-06-19 14:09:03
Message-ID: 200206191509.04984.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shaun Thomas 2002-06-19 14:30:23 Re: db grows and grows
Previous Message Alxander A. Kapralov 2002-06-19 14:08:01 what different beetwen "begin work; " and "begin transaction; " ????