In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Rory
Campbell-Lange) transmitted:
Essentially the call (as defined below) asks for an update and adds
a LIMIT parameter on the end of the UPDATE. (eg update where x=1
limit 1). Postgres doesn't like this and I assume it
Rory Campbell-Lange wrote:
Essentially the call (as defined below) asks for an update and adds a
LIMIT parameter on the end of the UPDATE. (eg update where x=1 limit 1).
Postgres doesn't like this and I assume it isn't SQL standards
compliant and need to refer to this in my bug report.
As far as
Rory Campbell-Lange writes:
I've downloaded the sql document archives from
postgresql.org/postgresql/doc/sql but it isn't clear to me how to
discern what is legal in an UPDATE statement.
Certainly LIMIT is not. Although LIMIT is a key word in the SQL standard,
it isn't used for anything, so