From: <ke...@us...> - 2006-08-22 09:32:21
|
Revision: 3522 Author: kevca Date: 2006-08-22 02:32:14 -0700 (Tue, 22 Aug 2006) ViewCVS: http://svn.sourceforge.net/mailmanager/?rev=3522&view=rev Log Message: ----------- Deal with strong typing in postgres Modified Paths: -------------- MailManager/branches/RELENG_2_1/sql/v2_1/reportCacheClosed.inc MailManager/branches/RELENG_2_1/sql/v2_1/reportCacheReceived.inc Modified: MailManager/branches/RELENG_2_1/sql/v2_1/reportCacheClosed.inc =================================================================== --- MailManager/branches/RELENG_2_1/sql/v2_1/reportCacheClosed.inc 2006-08-22 09:30:24 UTC (rev 3521) +++ MailManager/branches/RELENG_2_1/sql/v2_1/reportCacheClosed.inc 2006-08-22 09:32:14 UTC (rev 3522) @@ -43,11 +43,11 @@ SELECT COALESCE(table_count.ticket_count, user_count.ticket_count) AS ticket_count, - NULL AS account, + <dtml-var sql_nullastext> AS account, COALESCE(table_count.assigned, user_count.assigned) AS assigned, - NULL AS category0, - NULL AS category1, - NULL AS category2 + <dtml-var sql_nullastext> AS category0, + <dtml-var sql_nullastext> AS category1, + <dtml-var sql_nullastext> AS category2 FROM ( <dtml-comment> @@ -103,10 +103,10 @@ COALESCE(table_count.ticket_count, account_count.ticket_count) AS ticket_count, COALESCE(table_count.account_id, account_count.account_id) AS account, - NULL AS assigned, - NULL AS category0, - NULL AS category1, - NULL AS category2 + <dtml-var sql_nullastext> AS assigned, + <dtml-var sql_nullastext> AS category0, + <dtml-var sql_nullastext> AS category1, + <dtml-var sql_nullastext> AS category2 FROM ( @@ -163,11 +163,11 @@ SELECT COALESCE(table_count.ticket_count, category_count.ticket_count) AS ticket_count, - NULL AS account, - NULL AS assigned, + <dtml-var sql_nullastext> AS account, + <dtml-var sql_nullastext> AS assigned, COALESCE(table_count.category0, category_count.category0) AS category0, - NULL AS category1, - NULL AS category2 + <dtml-var sql_nullastext> AS category1, + <dtml-var sql_nullastext> AS category2 FROM ( @@ -225,11 +225,11 @@ SELECT COALESCE(table_count.ticket_count, category_count.ticket_count) AS ticket_count, - NULL AS account, - NULL AS assigned, - NULL AS category0, + <dtml-var sql_nullastext> AS account, + <dtml-var sql_nullastext> AS assigned, + <dtml-var sql_nullastext> AS category0, COALESCE(table_count.category1, category_count.category1) AS category1, - NULL AS category2 + <dtml-var sql_nullastext> AS category2 FROM ( <dtml-comment> @@ -286,10 +286,10 @@ SELECT COALESCE(table_count.ticket_count, category_count.ticket_count) AS ticket_count, - NULL AS account, - NULL AS assigned, - NULL AS category0, - NULL AS category1, + <dtml-var sql_nullastext> AS account, + <dtml-var sql_nullastext> AS assigned, + <dtml-var sql_nullastext> AS category0, + <dtml-var sql_nullastext> AS category1, COALESCE(table_count.category2, category_count.category2) AS category2 FROM ( Modified: MailManager/branches/RELENG_2_1/sql/v2_1/reportCacheReceived.inc =================================================================== --- MailManager/branches/RELENG_2_1/sql/v2_1/reportCacheReceived.inc 2006-08-22 09:30:24 UTC (rev 3521) +++ MailManager/branches/RELENG_2_1/sql/v2_1/reportCacheReceived.inc 2006-08-22 09:32:14 UTC (rev 3522) @@ -37,11 +37,11 @@ SELECT COALESCE(table_count.ticket_count, user_count.ticket_count) AS ticket_count, - NULL AS account, + <dtml-var sql_nullastext> AS account, COALESCE(table_count.assigned, user_count.assigned) AS assigned, - NULL AS category0, - NULL AS category1, - NULL AS category2 + <dtml-var sql_nullastext> AS category0, + <dtml-var sql_nullastext> AS category1, + <dtml-var sql_nullastext> AS category2 FROM ( @@ -92,10 +92,10 @@ COALESCE(table_count.ticket_count, account_count.ticket_count) AS ticket_count, COALESCE(table_count.account_id, account_count.account_id) AS account_id, - NULL AS assigned, - NULL AS category0, - NULL AS category1, - NULL AS category2 + <dtml-var sql_nullastext> AS assigned, + <dtml-var sql_nullastext> AS category0, + <dtml-var sql_nullastext> AS category1, + <dtml-var sql_nullastext> AS category2 FROM ( @@ -132,11 +132,11 @@ SELECT COALESCE(table_count.ticket_count, category_count.ticket_count) AS ticket_count, - NULL AS account, - NULL AS assigned, + <dtml-var sql_nullastext> AS account, + <dtml-var sql_nullastext> AS assigned, COALESCE(table_count.category0, category_count.category0) AS category0, - NULL AS category1, - NULL AS category2 + <dtml-var sql_nullastext> AS category1, + <dtml-var sql_nullastext> AS category2 FROM ( @@ -174,11 +174,11 @@ SELECT COALESCE(table_count.ticket_count, category_count.ticket_count) AS ticket_count, - NULL AS account, - NULL AS assigned, - NULL AS category0, + <dtml-var sql_nullastext> AS account, + <dtml-var sql_nullastext> AS assigned, + <dtml-var sql_nullastext> AS category0, COALESCE(table_count.category1, category_count.category1) AS category1, - NULL AS category2 + <dtml-var sql_nullastext> AS category2 FROM ( @@ -216,10 +216,10 @@ SELECT COALESCE(table_count.ticket_count, category_count.ticket_count) AS ticket_count, - NULL AS account, - NULL AS assigned, - NULL AS category0, - NULL AS category1, + <dtml-var sql_nullastext> AS account, + <dtml-var sql_nullastext> AS assigned, + <dtml-var sql_nullastext> AS category0, + <dtml-var sql_nullastext> AS category1, COALESCE(table_count.category2, category_count.category2) AS category2 FROM ( This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |