Re: [PATCH] PostgreSQL DLR speedup

On 10.11.2006, at 18:52, Georg von Zezschwitz wrote:

> Alexander Malysh schrieb:
>> Hi,
>>
>> Andreas , this is not true what you say. Mysql use LIMIT 1 in  
>> delete and update. Postgres should use oid because there is not  
>> limit support.
>>

This was not about LIMIT 1 (there was a reason for that) but about  
doing DELETE  and SELECT in one statement.
The LIMIT 1 was a workaround in the error of EMI protocol not giving  
unique timestamps.
the timestamp on a SMSC is not unique, not even for one destination  
number.