This is a discussion on DELETE & INSERT in a function within the pgsql Novice forums, part of the PostgreSQL category; --> Hi All, If I have a DELETE operation and an INSERT operation in a function will the DELETE operation ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi All, If I have a DELETE operation and an INSERT operation in a function will the DELETE operation be performed after the INSERT regardless of the order inside the function? I am seeing some behavior using PostgreSQL v7.3.6 that I do not understand. Kind Regards, Keith ______________________________________________ 99main Internet Services http://www.99main.com ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings |
| ||||
| Hi Keith , > > If I have a DELETE operation and an INSERT operation in a function will the > DELETE operation be performed after the INSERT regardless of the order inside > the function? They must work in the order specified. > I am seeing some behavior using PostgreSQL v7.3.6 that I do not > understand. Please do let us know more. -- With Best Regards, Vishal Kashyap. http://vishalkashyap.tk ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) |