SQLite CVSTrac

*** 176,181 ****
--- 176,187 ----
  *: DISTINCT ON (expr,...) - this is from Postgres, where expr,... must be the leftmost expressions from
  the ORDER BY clause
  
+ *: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.
+ 
+ *:FLOOR and CEILING functions, e.g. "SELECT FLOOR(salary) FROM personnel;"
+ 
  *: MEDIAN and standard deviation... are they standard?  Essential for sqlite standalone executable for
  shell script users.
  
***************
*** 210,223 ****
  
  *: name columns in views (i.e. CREATE VIEW (foo, bar) AS SELECT qux, quo FROM baz;)
  
- *:FLOOR and CEILING functions, e.g. "SELECT FLOOR(salary) FROM personnel;"
- 
- *:IF EXISTS function, e.g. "DROP TABLE IF EXISTS temp;"
- 
- *: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.
- 
  *:More than one primary key per table, I can specify this with MySQL for example and SQLite returns me
  an error: more than one primary key specified...
  
--- 216,221 ----
***************
*** 548,553 ****
--- 546,555 ----
  ====
  FEATURES ADDED IN RECENT VERSIONS
  ====
+ *:IF EXISTS function, e.g. "DROP TABLE IF EXISTS temp;"
+ 
+ _:Added in 3.3
+ 
  *: Extended POSIX regular expressions (should be easy, man 3 regcomp, or http://
  mirbsd.bsdadvocacy.org/man3/regcomp.htm for reference)
     SELECT * FROM table WHERE name REGEX '[a-zA-Z]+_{0,3}';

sqlite - Unsupported Sql