[GENERAL] Query on Oracle 10g Merge Function equivalent command/function in Postgre

Query on database migration  We are thinking of migrating one application from Oracle 10g to Postgre environment. We are using Oracle 10g Merge functionality to comprae and filter out the  records into two groups. The master database size is having about 11 million r

[GENERAL] Job scheduling in Postgre

I have certain jobs  to be executed automatically at a given interval of time in the postgre SQL database. Is their any utility/feature available in Postgre to do so.with regards, I.P.S. Sethi

[GENERAL] concurrent users

Dear All,I am planning to migrate my database from Oracle 10g to Postgre SQL. The database in Oracle currently have about 21 million records and about 2 million new record  are getting added every month. I have few queries: a. I get the data from user in excel/csv file (maximum 13 records per f

[GENERAL] commit/rollback in postgre 8.2

Is it possible to use begin, commit and rollback commands within a transaction block in SQL function in postgre ver 8.2 with regards, I.P.S. Sethi