From: <to...@us...> - 2005-10-29 04:03:45
|
Update of /cvsroot/tikiwiki/tiki/db/convertscripts In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24202 Modified Files: Tag: BRANCH-1-9 mysql3topgsql72.php Log Message: A pg MAX(boolean) for aventurous coders Index: mysql3topgsql72.php =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/convertscripts/mysql3topgsql72.php,v retrieving revision 1.9.6.10 retrieving revision 1.9.6.11 diff -u -d -r1.9.6.10 -r1.9.6.11 --- mysql3topgsql72.php 28 Oct 2005 23:50:18 -0000 1.9.6.10 +++ mysql3topgsql72.php 29 Oct 2005 04:03:38 -0000 1.9.6.11 @@ -39,6 +39,11 @@ create function right(text, integer) returns text AS \' select substring($1 from char_length($1) +1 - $2) as result \' language \'sql\'; +drop function fun_or(boolean, boolean); +create function fun_or(boolean, boolean) returns boolean as \' +select $1 or $2 as result\' language \'sql\'; +drop aggregate max (boolean); +create aggregate max (basetype=boolean, sfunc=fun_or, stype=boolean); '; // step though statements |