Frequently Asked Questions

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(Other FAQs: Add list of test frameworks)
(how do you create recurrence event?)
 
Line 32: Line 32:
  
 
[[Category:FAQ]]
 
[[Category:FAQ]]
 +
 +
I am trying to port sybase codse to posgresql.  I looked at the documentation but couldn't find
 +
good instruction on how to create a recurrence event which similar to the sybase codes below.
 +
 +
Can some one help?
 +
 +
create event PURGE_ORDER
 +
schedule
 +
        start time '00:00:00' every 30 minutes
 +
        on ( 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday','Saturday', 'Sunday' )
 +
handler
 +
begin
 +
      declare @value          varchar(128);
 +
      call cleanup_order();
 +
end;

Latest revision as of 00:07, 21 September 2013

Contents

[edit] Official FAQs

The official FAQs are in the process of being migrated to the wiki. For those not listed on this page, see Official FAQs on the website.

[edit] General FAQs

[edit] Platform FAQs


[edit] Other FAQs

[edit] Asking questions

Please read the Guide to reporting problems before posting a question not answered in the FAQ. You're more likely to get a better answer, sooner.

I am trying to port sybase codse to posgresql. I looked at the documentation but couldn't find good instruction on how to create a recurrence event which similar to the sybase codes below.

Can some one help?

create event PURGE_ORDER schedule

       start time '00:00:00' every 30 minutes
       on ( 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday','Saturday', 'Sunday' )

handler begin

     declare @value           varchar(128); 
     call cleanup_order();

end;

Personal tools