*** 5,10 ****
--- 5,15 ----
below.
----
+
+ *: 2006.09.15 : CREATE DOMAIN
+
+ CREATE DOMAIN code_postal_us AS TEXT;
+
*: 2006.05.19 : UPDATE with LIMIT clause:
UPDATE table SET col = 'value', col2 = 'value2'
***************
*** 31,37 ****
This is Sybase ASE syntax. Use LEFT JOIN or RIGHT JOIN instead.
(This is related to "Oracle's join syntax" mentioned below.)
! *: 2005.12.27 : Oracle's Named Parameter output syntax. In Oracle, one can declare parameters and select into them as such
Select A1, A2, A3 into (:p1, :p2, :p3) from TableA
--- 36,43 ----
This is Sybase ASE syntax. Use LEFT JOIN or RIGHT JOIN instead.
(This is related to "Oracle's join syntax" mentioned below.)
! *: 2005.12.27 : Oracle's Named Parameter output syntax. In Oracle, one can declare parameters and
! select into them as such
Select A1, A2, A3 into (:p1, :p2, :p3) from TableA
***************
*** 45,55 ****
*: 2005.08.25 : The ALL and ANY quantifiers for comparisons with subquery results aren't supported.
! *: 2005.08.03 : UPDATE table SET x WHERE y ORDER BY z is not supported. Haven't tried the LIMIT addition to that form.
! *: 2005.06.01 : Named parts of natural joins. For example: SELECT a.c1 FROM T1 a NATURAL JOIN T1 b. Because sqlite reduces the number of columns kept, the name is lost.
! *: 2005.04.27 : DELETE from table ORDER BY column LIMIT x,y is not supported. I worked around it by using a second query and deleting, eg:
SELECT timestamp from table LIMIT
x,1; DELETE from table
--- 51,64 ----
*: 2005.08.25 : The ALL and ANY quantifiers for comparisons with subquery results aren't supported.
! *: 2005.08.03 : UPDATE table SET x WHERE y ORDER BY z is not supported. Haven't tried the LIMIT
! addition to that form.
! *: 2005.06.01 : Named parts of natural joins. For example: SELECT a.c1 FROM T1 a NATURAL JOIN T1 b.
! Because sqlite reduces the number of columns kept, the name is lost.
! *: 2005.04.27 : DELETE from table ORDER BY column LIMIT x,y is not supported. I worked around it by
! using a second query and deleting, eg:
SELECT timestamp from table LIMIT
x,1; DELETE from table
***************
*** 71,77 ****
*: 2004.07.29 : UPDATE t1, t2 SET t1.f1 = value WHERE t1.f2 = t2.fa
! *: 2004.04.25 : a password('') function to mask some values (as used in MySQL) would be fine, I need it, if I give the db out of the house, or is there something I didn't find? Or a simple MD5 function to obscure data
using a one way hash. See the MySQL function MD5 or Password for examples.
--- 80,88 ----
*: 2004.07.29 : UPDATE t1, t2 SET t1.f1 = value WHERE t1.f2 = t2.fa
! *: 2004.04.25 : a password('') function to mask some values (as used in MySQL) would be fine, I need it,
! if I give the db out of the house, or is there something I didn't find? Or a simple MD5 function to
! obscure data
using a one way hash. See the MySQL function MD5 or Password for examples.
***************
*** 83,93 ****
*: 2004.02.25 : name columns in views (i.e. CREATE VIEW (foo, bar) AS SELECT qux, quo FROM baz;)
! *: 2004.01.08 : MEDIAN and standard deviation... are they standard? Essential for sqlite standalone executable for shell script users.
_:_MEDIAN is difficult because it cannot be done "on-line," i.e., on a stream
of data. Following is a
! solution to MEDIAN credited to David Rozenshtein, Anatoly Abramovich, and
Eugene Birger; it is
explained here: http://www.oreilly.com/catalog/transqlcook/chapter/ch08.html
--- 94,106 ----
*: 2004.02.25 : name columns in views (i.e. CREATE VIEW (foo, bar) AS SELECT qux, quo FROM baz;)
! *: 2004.01.08 : MEDIAN and standard deviation... are they standard? Essential for sqlite standalone
! executable for shell script users.
_:_MEDIAN is difficult because it cannot be done "on-line," i.e., on a stream
of data. Following is a
! solution to MEDIAN credited to David Rozensh
! tein, Anatoly Abramovich, and
Eugene Birger; it is
explained here: http://www.oreilly.com/catalog/transqlcook/chapter/ch08.html
***************
*** 100,112 ****
SUM(CASE WHEN y.Hours >= x.Hours
THEN 1 ELSE 0 END)>=(COUNT(*)/2)+1
! *: 2004.01.01 : DISTINCT ON (expr,...) - this is from Postgres, where expr,... must be the leftmost expressions from the ORDER BY clause
! *: 2003.10.30 : INSERTing fewer values than columns does not fill the missing columns with the default values; if fewer values than columns in the table are supplied, all columns filled have to be named before the keyword values
*: 2003.09.04 : Multi-column IN clause (ie. SELECT * FROM tab WHERE (key1, key2) IN (SELECT...)
! *: 2003.08.29 : UPDATE with a FROM clause (not sure if this is standard, Sybase and Microsoft have it). -> UnsupportedSqlUpdateWithFrom
*: 2003.08.06 : ALTER VIEW, ALTER TRIGGER, ALTER TABLE
--- 113,129 ----
SUM(CASE WHEN y.Hours >= x.Hours
THEN 1 ELSE 0 END)>=(COUNT(*)/2)+1
! *: 2004.01.01 : DISTINCT ON (expr,...) - this is from Postgres, where expr,... must be the leftmost
! expressions from the ORDER BY clause
! *: 2003.10.30 : INSERTing fewer values than columns does not fill the missing columns with the default
! values; if fewer values than columns in the table are supplied, all columns filled have to be named
! before the keyword values
*: 2003.09.04 : Multi-column IN clause (ie. SELECT * FROM tab WHERE (key1, key2) IN (SELECT...)
! *: 2003.08.29 : UPDATE with a FROM clause (not sure if this is standard, Sybase and Microsoft have it).
! -> UnsupportedSqlUpdateWithFrom
*: 2003.08.06 : ALTER VIEW, ALTER TRIGGER, ALTER TABLE
***************
*** 115,121 ****
do sqlite_open(). To drop a database, delete the file._
! *: 2003.08.06 : Schemas - See: http://www.postgresql.org/docs/8.1/static/ddl-schemas.html -> UnsupportedSqlSchemas
*: 2003.08.06 : TRUNCATE (MySQL, Postgresql and Oracle have it... but I dont know if this is
a standard command) -
--- 132,139 ----
do sqlite_open(). To drop a database, delete the file._
! *: 2003.08.06 : Schemas - See: http://www.postgresql.org/docs/8.1/static/ddl-schemas.html ->
! UnsupportedSqlSchemas
*: 2003.08.06 : TRUNCATE (MySQL, Postgresql and Oracle have it... but I dont know if this is
a standard command) -
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|