 --
 -- For the tests to execute successfully this file should 
 -- be run against a blank database called 'pgkit_test' and 
--- the user 'pgkit_test' with password 'pgkit' should exit:
+-- the user 'pgkit_test' with password 'pgkit' should exist:
 --
 -- CREATE DATABASE pgkit_test;
 -- CREATE USER pgkit_test WITH PASSWORD 'pgkit';
 
-BEGIN;
-
 SET datestyle = 'DMY';
 SET client_encoding = 'UNICODE';
 
-IF EXISTS (
-	SELECT 1 FROM information_schema.tables 
-	WHERE table_name = 'data_types' 
-	AND table_type = 'BASE TABLE'
-)
-	DROP TABLE data_types;
-END
+BEGIN;
+
+DROP TABLE IF EXISTS data_types;
 
 CREATE TABLE data_types
 (

	'02:02:02',
	'02:02:02 GMT',
	'08-04-1987 02:02:02',
	'08-04-1987 02:02:02 GMT')

COMMIT;


	bigint_field      BIGINT NOT NULL,
	bool_field        BOOL NOT NULL,
	float_field       REAL NOT NULL,
	numeric_field     NUMERIC(8, 3) NOT NULL,
	char_field        CHAR(4) NOT NULL,
	varchar_field     VARCHAR(32) NOT NULL,
	date_field        DATE NOT NULL,
