Re: [PATCH] PostgreSQL DLR speedup

Am 14.11.2006, 14:36 Uhr, schrieb Andreas Fink <[email protected]>:

>
> 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.

Postgres doesn't support LIMIT 1 so there no way except with subselect to  
tell postgres to delete only one row.

>
>
>
>



-- 
Thanks,
Alex