summaryrefslogtreecommitdiff
path: root/docs/db-api.txt
diff options
context:
space:
mode:
authorJacob Kaplan-Moss <jacob@jacobian.org>2007-06-27 19:16:05 +0000
committerJacob Kaplan-Moss <jacob@jacobian.org>2007-06-27 19:16:05 +0000
commita9807db5528637c86f3912b919d13223b6346bf2 (patch)
tree9e8cfa7aa1bd66482b185b00394549c71ad94b36 /docs/db-api.txt
parent24512a74befc6282a1d299cab452ee9463cc2baa (diff)
Fixed #4712: added mention of Oracle in docs from [5555]. Thanks, Tom.
git-svn-id: http://code.djangoproject.com/svn/django/trunk@5556 bcc190cf-cafb-0310-a4f2-bffc1f526a37
Diffstat (limited to 'docs/db-api.txt')
-rw-r--r--docs/db-api.txt8
1 files changed, 6 insertions, 2 deletions
diff --git a/docs/db-api.txt b/docs/db-api.txt
index 9284c9994c..51e1e65037 100644
--- a/docs/db-api.txt
+++ b/docs/db-api.txt
@@ -1189,14 +1189,16 @@ SQL equivalents::
SELECT ... WHERE title REGEXP BINARY '^(An?|The) +'; -- MySQL
+ SELECT ... WHERE REGEXP_LIKE(title, '^(an?|the) +', 'c'); -- Oracle
+
SELECT ... WHERE title ~ '^(An?|The) +'; -- PostgreSQL
SELECT ... WHERE title REGEXP '^(An?|The) +'; -- sqlite
Using raw strings for passing in the regular expression syntax is recommended.
-Regular expression matching is not supported on the ``ado_mssql`` and
-``oracle`` backends; these will raise a ``NotImplementedError``.
+Regular expression matching is not supported on the ``ado_mssql`` backend; it
+will raise a ``NotImplementedError``.
iregex
~~~~~~
@@ -1211,6 +1213,8 @@ SQL equivalents::
SELECT ... WHERE title REGEXP '^(an?|the) +'; -- MySQL
+ SELECT ... WHERE REGEXP_LIKE(title, '^(an?|the) +', 'i'); -- Oracle
+
SELECT ... WHERE title ~* '^(an?|the) +'; -- PostgreSQL
SELECT ... WHERE title REGEXP '(?i)^(an?|the) +'; -- sqlite