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.
