#17186: Inverted F expression (negation)
-------------------------------------+-------------------------------------
Reporter: niwi | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: SVN
(models, ORM) | Resolution:
Severity: Normal | Triage Stage: Accepted
Keywords: | Needs documentation: 1
Has patch: 1 | Patch needs improvement: 1
Needs tests: 1 | UI/UX: 0
Easy pickings: 0 |
-------------------------------------+-------------------------------------
Comment (by zsiciarz):
Apparently various database engines work differently regarding negation of
non-boolean values. For example on Postgres each of the following queries
raises an error:
{{{
SELECT NOT 5;
SELECT NOT "5";
SELECT NOT "5abc";
}}}
while on SQLite it happily returns 0. SQLite casts the expression to a
NUMERIC value when used in a boolean context, so in each case it is
"truthy".
--
Ticket URL: <https://code.djangoproject.com/ticket/17186#comment:10>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en.
