aboutsummaryrefslogtreecommitdiffstats
path: root/include/dblayer/functions_pgsql.inc.php (follow)
Commit message (Collapse)AuthorAgeFilesLines
* merge r10430 from branch 2.2 to trunkplegall2011-04-161-1/+72
| | | | | | | | bug 1818 fixed: fix "select distinct" queries for PostgreSQL. Patch by leloupv git-svn-id: http://piwigo.org/svn/trunk@10431 68402e56-0260-453c-a942-63ccdbb3a9ee
* Happy new year 2011plegall2011-01-181-2/+2
| | | | | | | Change "Piwigo - a PHP based picture gallery" into "Piwigo - a PHP based photo gallery" git-svn-id: http://piwigo.org/svn/trunk@8728 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1766 fixed : [PostgreSQL] unkown database function UNIX_TIMESTAMP()nikrou2010-07-061-0/+5
| | | | | | Add a new function pwg_db_date_to_ts() to calculate a timestamp from a date git-svn-id: http://piwigo.org/svn/trunk@6666 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1744 fixed : Incorrect use of timezone with SQLitenikrou2010-06-251-0/+5
| | | | | | | | Fixed anti-flood system. Need refactoring between each interval functions git-svn-id: http://piwigo.org/svn/trunk@6604 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1743 fixed : comment form is not visible because of boolean managementnikrou2010-06-231-0/+4
| | | | git-svn-id: http://piwigo.org/svn/trunk@6591 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1737 fixed : Concatenation error with POstgreSQLnikrou2010-06-221-4/+2
| | | | | | Simplify same function for SQLite git-svn-id: http://piwigo.org/svn/trunk@6580 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1738 fixed : hour function doesn't exists for database other than mysql.nikrou2010-06-221-0/+5
| | | | git-svn-id: http://piwigo.org/svn/trunk@6578 68402e56-0260-453c-a942-63ccdbb3a9ee
* Fix bug 1722 : PosgtreSQL wants all fields in select to be in Group by clausenikrou2010-06-091-4/+4
| | | | | | | or agregate function Fix issue for lambda function (incorrect number of params) git-svn-id: http://piwigo.org/svn/trunk@6510 68402e56-0260-453c-a942-63ccdbb3a9ee
* Fix bug 1695 : incorrect boolean to string conversion for SQLite and ↵nikrou2010-05-241-3/+3
| | | | | | PostgreSQL database engines git-svn-id: http://piwigo.org/svn/trunk@6339 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 1648 fixed: add the pwg_db_check_version functions for pdo-sqlite, sqliteplegall2010-05-071-0/+15
| | | | | | | | | | and pgsql, also make the $pwg_db_link global in the install_db_connect function so that it can be used in SQLite functions. bug fixed: with pdo-sqlite, pwg_db_num_rows always returns 0, so when initializing user data, it tries to insert the same row twice. git-svn-id: http://piwigo.org/svn/trunk@6090 68402e56-0260-453c-a942-63ccdbb3a9ee
* Fix warning for postgresql installationnikrou2010-03-221-6/+1
| | | | | | Remove unused function git-svn-id: http://piwigo.org/svn/trunk@5267 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1255 :nikrou2010-03-211-4/+10
| | | | | | | only one function use exceptions to deal with differents possible errors git-svn-id: http://piwigo.org/svn/trunk@5236 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 1255: add pwg_select_db function.patdenice2010-03-211-2/+7
| | | | git-svn-id: http://piwigo.org/svn/trunk@5230 68402e56-0260-453c-a942-63ccdbb3a9ee
* increase copyright year to 2010plegall2010-03-191-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@5196 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1451 : fix mispelling and missing translationsnikrou2010-03-031-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@5036 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1255 : bug in install with mysql and postgresql if some form ↵nikrou2010-02-281-1/+1
| | | | | | parameters are missing. git-svn-id: http://piwigo.org/svn/trunk@5006 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1255 :nikrou2010-02-151-2/+8
| | | | | | | update pwg_db_insert_id() function. PosgreSQL needs table name to retrieve last insert auto increment id. git-svn-id: http://piwigo.org/svn/trunk@4892 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1255 : bug in pwg_session_write() with postgresql.nikrou2010-02-131-1/+29
| | | | | | replace into doesn't exists. Must do two queries git-svn-id: http://piwigo.org/svn/trunk@4886 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 511 : fix problems with calendar functionsnikrou2010-02-031-0/+6
| | | | | | add pwg_db_concat() function git-svn-id: http://piwigo.org/svn/trunk@4833 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 511 : add support for sqlite database enginenikrou2010-01-281-52/+14
| | | | | | Using session_write_close function when session handler use database because write is called after object destruction. git-svn-id: http://piwigo.org/svn/trunk@4781 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1255 :nikrou2009-12-021-0/+581
- add postgres database engine - change installation process to allow postgres or mysql database git-svn-id: http://piwigo.org/svn/trunk@4410 68402e56-0260-453c-a942-63ccdbb3a9ee