Frequently Asked Questions

From PostgreSQL wiki

Jump to: navigation, search

Contents

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.

General FAQs

Platform FAQs


Other FAQs

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