-<p>
-<pre>
- danmorg@DANPC ~/mono/mcs/class/System.Data/Test\r
- $ mcs PostgresTest.cs -r System.Data.dll\r
-\r
- danmorg@DANPC ~/mono/mcs/class/System.Data/Test\r
- $ mono PostgresTest.exe\r
- Postgres provider specific tests...\r
-\r
- Drop table:\r
- Error (don't worry about this one)SqlError:PGRES_FATAL_ERROR ERROR: \r
- table "mono_postgres_test" does not exist\r
- <Stack Trace>\r
-\r
- Create table with all supported types:\r
- OK\r
- Insert values for all known types:\r
- OK\r
- Update values:\r
- OK\r
- Insert values for all known types:\r
- OK\r
- Aggregate: count(*)\r
- Agg Result: 2\r
- Aggregate: min(text_value)\r
- Agg Result: This is a text\r
- Aggregate: max(int4_value)\r
- Agg Result: 1048000\r
- Aggregate: sum(int4_value)\r
- Agg Result: 1048003\r
- Select values from the database:\r
- Get Schema.\r
- dt.Columns.Count: 28\r
- * Column Name: boolean_value\r
- MaxLength: 1\r
- Type: System.Boolean\r
- * Column Name: int2_value\r
- MaxLength: 2\r
- Type: System.Int16\r
- * Column Name: int4_value\r
- MaxLength: 4\r
- Type: System.Int32\r
- * Column Name: bigint_value\r
- MaxLength: 8\r
- Type: System.Int64\r
- * Column Name: float_value\r
- MaxLength: 4\r
- Type: System.Single\r
- * Column Name: double_value\r
- MaxLength: 8\r
- Type: System.Double\r
- * Column Name: numeric_value\r
- MaxLength: -1\r
- Type: System.Decimal\r
- * Column Name: char_value\r
- MaxLength: -1\r
- Type: System.String\r
- * Column Name: varchar_value\r
- MaxLength: -1\r
- Type: System.String\r
- * Column Name: text_value\r
- MaxLength: -1\r
- Type: System.String\r
- * Column Name: point_value\r
- MaxLength: 16\r
- Type: System.String\r
- * Column Name: time_value\r
- MaxLength: 8\r
- Type: System.DateTime\r
- * Column Name: date_value\r
- MaxLength: 4\r
- Type: System.DateTime\r
- * Column Name: timestamp_value\r
- MaxLength: 8\r
- Type: System.DateTime\r
- * Column Name: null_boolean_value\r
- MaxLength: 1\r
- Type: System.Boolean\r
- * Column Name: null_int2_value\r
- MaxLength: 2\r
- Type: System.Int16\r
- * Column Name: null_int4_value\r
- MaxLength: 4\r
- Type: System.Int32\r
- * Column Name: null_bigint_value\r
- MaxLength: 8\r
- Type: System.Int64\r
- * Column Name: null_float_value\r
- MaxLength: 4\r
- Type: System.Single\r
- * Column Name: null_double_value\r
- MaxLength: 8\r
- Type: System.Double\r
- * Column Name: null_numeric_value\r
- MaxLength: -1\r
- Type: System.Decimal\r
- * Column Name: null_char_value\r
- MaxLength: -1\r
- Type: System.String\r
- * Column Name: null_varchar_value\r
- MaxLength: -1\r
- Type: System.String\r
- * Column Name: null_text_value\r
- MaxLength: -1\r
- Type: System.String\r
- * Column Name: null_point_value\r
- MaxLength: 16\r
- Type: System.String\r
- * Column Name: null_time_value\r
- MaxLength: 8\r
- Type: System.DateTime\r
- * Column Name: null_date_value\r
- MaxLength: 4\r
- Type: System.DateTime\r
- * Column Name: null_timestamp_value\r
- MaxLength: 8\r
- Type: System.DateTime\r
- Row 0:\r
- Col 0: boolean_value: False\r
- Col 1: int2_value: 5\r
- Col 2: int4_value: 3\r
- Col 3: bigint_value: 9\r
- Col 4: float_value: 3.141590\r
- Col 5: double_value: 3.141593\r
- Col 6: numeric_value: 123456789012.345\r
- Col 7: char_value: Mono.Data!\r
- Col 8: varchar_value: It was not me!\r
- Col 9: text_value: We got data!\r
- Col 10: point_value: (1,0)\r
- Col 11: time_value: Monday, 01 January 1 21:13:14\r
- Col 12: date_value: Tuesday, 29 February 2000 00:00:00\r
- Col 13: timestamp_value: Sunday, 29 February 2004 14:00:11\r
- Col 14: null_boolean_value is NULL\r
- Col 15: null_int2_value is NULL\r
- Col 16: null_int4_value is NULL\r
- Col 17: null_bigint_value is NULL\r
- Col 18: null_float_value is NULL\r
- Col 19: null_double_value is NULL\r
- Col 20: null_numeric_value is NULL\r
- Col 21: null_char_value is NULL\r
- Col 22: null_varchar_value is NULL\r
- Col 23: null_text_value is NULL\r
- Col 24: null_point_value is NULL\r
- Col 25: null_time_value is NULL\r
- Col 26: null_date_value is NULL\r
- Col 27: null_timestamp_value is NULL\r
- Row 1:\r
- Col 0: boolean_value: True\r
- Col 1: int2_value: -22\r
- Col 2: int4_value: 1048000\r
- Col 3: bigint_value: 123456789012345\r
- Col 4: float_value: 3.141590\r
- Col 5: double_value: 3.141593\r
- Col 6: numeric_value: 123456789012.345\r
- Col 7: char_value: This is a char\r
- Col 8: varchar_value: This is a varchar\r
- Col 9: text_value: This is a text\r
- Col 10: point_value: (1,0)\r
- Col 11: time_value: Monday, 01 January 1 21:13:14\r
- Col 12: date_value: Tuesday, 29 February 2000 00:00:00\r
- Col 13: timestamp_value: Sunday, 29 February 2004 14:00:11\r
- Col 14: null_boolean_value is NULL\r
- Col 15: null_int2_value is NULL\r
- Col 16: null_int4_value is NULL\r
- Col 17: null_bigint_value is NULL\r
- Col 18: null_float_value is NULL\r
- Col 19: null_double_value is NULL\r
- Col 20: null_numeric_value is NULL\r
- Col 21: null_char_value is NULL\r
- Col 22: null_varchar_value is NULL\r
- Col 23: null_text_value is NULL\r
- Col 24: null_point_value is NULL\r
- Col 25: null_time_value is NULL\r
- Col 26: null_date_value is NULL\r
- Col 27: null_timestamp_value is NULL\r
- Rows: 2\r
- Calling stored procedure version()\r
- Result: PostgreSQL 7.2.1 on i686-pc-cygwin, compiled by GCC 2.95.3-5\r
- Database Server Version: PostgreSQL 7.2.1 on i686-pc-cygwin, compiled by GCC 2.9\r
- 5.3-5\r
- Clean up...\r
- Drop table...\r
- OK\r
- RESULT: 0\r
-\r
-</pre>\r
-\r