Module Name:	pkgsrc
Committed By:	mjl
Date:		Sun Apr  3 05:06:42 UTC 2005

Modified Files:
	pkgsrc/databases/p5-SQL-Statement: Makefile distinfo

Log Message:
Update to 0.11

 * added support for CREATE TABLE AS SELECT ... and CREATE TABLE AS IMPORT()
 * added support for in-memory tables and heterogeneous operations
 * added many new built-in functions see SQL::Statement::Functions.pm
 * added support for user-defined functions, see SQL::Statement::Functions.pm
 * added support for column name aliases
 * added support for comparison to empty string (e.g. WHERE col1='')
   currently returns the same as WHERE col1 IS NULL
 * clean up a number of bugs in parentheses parsing and in the
   predicates IN and BETWEEN as well as speed things up considerably
 * fixed function detection regex in SQL::Parser::ROW_VALUE
 	to accomodate arbitrary spacing
 * support concat operator '||' expressions
 * added following functions to SQL::Statement::Functions:
 	- COALESCE/NVL
 	- DECODE (same as Oracle DECODE)
 	- CONCAT
 	- REPLACE/SUBSTITUTE
 * fixed/adapted SQL::Statement::get_row_value(),
	SQL::Statement::SELECT(), for join'ed
 	resultsets
 * fixed infinite recursion bug with empty IN() predicate
 * fixed case issues with table aliases in joins
 * column and table name hashes now default to case sensitive
 * where() method now supported as per the docs


To generate a diff of this commit:
cvs rdiff -r1.15 -r1.16 pkgsrc/databases/p5-SQL-Statement/Makefile
cvs rdiff -r1.7 -r1.8 pkgsrc/databases/p5-SQL-Statement/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.