Re: How create SQL variable sentense in plpgsql?!

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: <mik(at)nix(dot)org(dot)ru>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: How create SQL variable sentense in plpgsql?!
Date: 2001-02-13 18:24:59
Message-ID: Pine.LNX.4.30.0102131924230.1615-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mikhail V. Majorov writes:

> I try to make multi-purpose trigger for make history off change in some
> tables.
> The main purpose is to do "INSERT INTO textcat(TG_NAME, '_history')
> VALUES (OLD)".
> Is it possible? I have all time error: ERROR: parser: parse error at or
> near "$1"

Upgrade to 7.1 and use the EXECUTE command, or write it in a different
programming language.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dan McGrath 2001-02-13 18:25:16 Re: Tuple is to big
Previous Message Anand Raman 2001-02-13 18:07:14 Re: [araman@india-today.com: locking problem with JDBC (suspicion)]