01e38acffe
Category:1990 non-fiction books
Category:1990 in science
Category:Pharmacology books
Category:History of chemistryQ:
Postgresql - After last modification at a certain time, prevent further updates until a certain time
I'm trying to create a view in postgresql that prevents new rows from being inserted or modified until a certain time has passed since the row was last modified.
For example, if a row in my table was modified at 1:30 PM, and I am querying that table at 2:15 PM, I would like the query to only return rows modified after 1:30 PM.
A:
If the first update on a row is an INSERT, there is no previous version of the row. Hence, the only option is to SELECT the row before it got updated. Something like this:
SELECT *
FROM mytable
WHERE id > (SELECT max(id) FROM mytable);
Be sure to use a transaction for this. Or you could get the INSERT-version of the row as a result of that query, or some other technique.
Just a reminder that your delivery will arrive in your mail in a few weeks! I will be ordering this again, and I also had them deliver the Sonicare Ultima. The fit is just perfect, and I am so impressed with the sound and overall style of this toothbrush! The brush head is great for my teeth, and the movement is really great. However, it is less than ideal for cleaning the rest of my mouth. I tried the Pure cleansing gel as well, and I must say that the Sonicare Ultima does a better job cleaning my teeth.
You guys at the Sonicare are truly awesome! I'm so happy to have found your company and am a huge fan now! :)
I received my Sonicare Ultima Oral Hygiene System yesterday. I first got a brush for my wife and I, and we had a little trouble, but then I got a second one for myself (and it fits me like a glove). Then I realized that it has two batteries (thank you!). I have to admit that the first one was a little hard to use for me, but I am now getting the hang of it and it works great! And now I will be buying brushes for my wife and my parents.
The Sonicare has been amazing for me. I hate getting up in the morning and taking 2 pills
Related links:
Comments