| From: | darthxiong(at)libero(dot)it |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | plpgsql and escape |
| Date: | 2002-10-21 15:00:12 |
| Message-ID: | 20021021150015.65FD6475F5A@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
hi all!
i'm trying to do this ( converting unix time to human readable time in another table )
create function align_vs() returns opaque as
'
declare
line_vs vs%ROWTYPE;
itime vs.step_time%TYPE;
begin
itime := to_char( timestamp ''epoch'' + interval ''NEW.step_time seconds'', ''YYYY-MM-DD HH24:MI:SS'' );
update vs set w_id = NEW.w_id, step_id = %NEW.step_id, step_time = itime where w_id = NEW.w_id;
return null;
end;
' language plpgsql;
the double ' around NEW.step_time blocks its interpolation. which is the correct escaping sintax here?
TIA
Ivan
--
There is no such thing as a problem without a gift for you in its hands.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert John Shepherd | 2002-10-21 15:08:20 | Can't compile --with-perl |
| Previous Message | Jeff MacDonald | 2002-10-21 14:59:21 | help with pgxml_xpath |