X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F46xml-to-pg.t;fp=t%2F46xml-to-pg.t;h=e3b35407a5951f2afeee47846ed0a26b88deb4d4;hb=296c27014d3aae53005b1727c7ab2397ba1a3346;hp=ced163fb0f5a5a4ab03479547b96000f779188ec;hpb=ec59a59706d3aede26dbdcfec8e3ba5d64e2d8f7;p=dbsrgits%2FSQL-Translator.git

diff --git a/t/46xml-to-pg.t b/t/46xml-to-pg.t
index ced163f..e3b3540 100644
--- a/t/46xml-to-pg.t
+++ b/t/46xml-to-pg.t
@@ -57,6 +57,12 @@ CREATE TABLE "Another" (
   PRIMARY KEY ("id")
 );
 
+
+
+CREATE OR REPLACE VIEW "email_list" ( "email" ) AS (
+    SELECT email FROM Basic WHERE email IS NOT NULL
+  );
+
 ALTER TABLE "Basic" ADD FOREIGN KEY ("another_id")
   REFERENCES "Another" ("id") DEFERRABLE;
 SQL