TURN;
END;
$BODY$
LANGUAGE plpgsql
Thank you for your consideration,
Leon
From: David Johnston [mailto:pol...@yahoo.com]
Sent: Tuesday, June 21, 2011 10:30 AM
To: 'Leon Match'; pgsql-general@postgresql.org
Subject: RE: [GENERAL] Call procedure from a Job, Test a Job in pgAdmin?
();
SELECT requests_curr_req();
EXECUTE requests_curr_req();
EXECUTE PROCEDURE requests_curr_req();
but nothing worked!?
Could you please advise the right way to do that?
Also, what would be the way to test in pgAdmin, if the Job is running at
all?
Thank you,
Leon Match
leon.ma
Kussama [mailto:osvaldo.kuss...@gmail.com]
Sent: Monday, June 20, 2011 3:45 PM
To: Leon Match
Subject: Re: [GENERAL] insert a SYSTIMESTAMP value in postgres
2011/6/20 Leon Match :
> Hello,
>
> I am trying to re-create few objects from oracle into postgres.
>
> I have a prob
Hello,
I am trying to re-create few objects from oracle into postgres.
I have a problem inserting a timestamp value into the table:
insert into request_queue (request_id, received_time
)
values (new.request_id, SYSTIME
Hello,
I am trying to move few objects to postgres from oracle.
I have an issue with a trigger, which has a merge inside?
Here is my code:
BEGIN
MERGE INTO Requests r
using (select
new.web_form_id web_form_id,
new.form_type form
