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 i
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, s
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 I