pltcl function -> plpgsql

From: "guard" <guard(at)ficnet(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: pltcl function -> plpgsql
Date: 2001-12-28 04:42:47
Message-ID: a0gt6a$1jvr$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

dear all

I have function >>
spi_exec "Update $1 set
adv_amt=adv_amt-$OLD(adv_amt)+$OLD(gadv_amt) where $2=''$OLD($2)'' "

how to change plpgsql code

ps. $1 a variable

thanks

--

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2001-12-28 05:11:00 Re: [SQL] An easy question about creating a primary key
Previous Message Rick Dayao 2001-12-28 02:54:30 Conditional test