jrmrenegade wrote:

>
> However, apparently PostgreSQL has a unique identifier called a ctid
> for each row that can be utilized in with a subquery like so:
>
> DELETE FROM a WHERE ctid=(SELECT ctid FROM a WHERE b=3 LIMIT 1);
>
> which is the function equivalent of MySQL's:
>
> DELETE FROM a WHERE b=3 LIMIT 1;
>
>
> So my question is: Is there any technique that I can apply to
> "emulate" the LIMIT option for DELETE statements in Firebird?
>

Not that I approve, but you could use the RDB$DB_KEY


Regards,


Ann