Re: How create SQL variable sentense in plpgsql?! - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: How create SQL variable sentense in plpgsql?!
Date
Msg-id Pine.LNX.4.30.0102131924230.1615-100000@peter.localdomain
Whole thread Raw
In response to How create SQL variable sentense in plpgsql?!  ("Mikhail V. Majorov" <mik@ttn.ru>)
List 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@gmx.net       http://yi.org/peter-e/


pgsql-general by date:

Previous
From: Anand Raman
Date:
Subject: Re: [araman@india-today.com: locking problem with JDBC (suspicion)]
Next
From: jdassen@cistron.nl (J.H.M. Dassen (Ray))
Date:
Subject: Re: Postmaster crashes