Inserting Integers will using plpgsql...

From: Scott Holmes <sholmes(at)pacificnet(dot)net>
To: pgsql-general(at)postgresql(dot)org (PG-General)
Subject: Inserting Integers will using plpgsql...
Date: 2001-05-17 21:45:39
Message-ID: 200105172145.OAA11564@scotts.mynetwork.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I figured it out but it's not pretty.

EXECUTE ''INSERT INTO journal (j_date,casenmbr,peopnmbr,evntnmbr,''
||''j_descr,j_rate,j_quant,j_status) VALUES (''
||quote_literal(jdate)
||'',''
||quote_literal(text(casenmbr))
||'',''
||quote_literal(text(peopnmbr))
||'',''
||quote_literal(text(param))
||'',''
||quote_literal(erec.ev_title)
||'',''
||quote_literal(text(erec.ev_rate))
||'',''
||quote_literal(text(erec.ev_amount))
||'',''
||quote_literal(jstatus)
||'')'';

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-05-17 21:45:51 Re: yet another stupid question (index coverage)
Previous Message Jeff Patterson 2001-05-17 21:24:22 RE: PL/Perl in 7.1.1