postgres does support LIMIT 1 in version 8.
On 15.11.2006, at 01:58, Alexander Malysh wrote:
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
