Postgres Pro
Downloads
Home   >   mailing lists

pltcl function -> plpgsql - Mailing list pgsql-sql

From guard
Subject pltcl function -> plpgsql
Date
Msg-id a0gt6a$1jvr$1@news.tht.net
Whole thread Raw
Responses Re: pltcl function -> plpgsql
List pgsql-sql
Tree view 
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




--

pgsql-sql by date:

Previous
From: "Alex Glikson"
Date:
Subject: OUTER JOIN doesn't work on pgSQL 7.1.2
Next
From: "Tom Kreiner"
Date:
Subject: Getting Hour From a Time in Different Time Zone