SF.net SVN: ledger-smb: [1870] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 1870
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=1870&view=rev
Author:   linuxpoet
Date:     2007-11-15 16:38:52 -0800 (Thu, 15 Nov 2007)

Log Message:
-----------
fix the location table... I would like to know who thought check (foo 'regex' NOT NULL) was going to work...

Modified Paths:
--------------
    trunk/sql/Pg-database.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-11-15 23:10:31 UTC (rev 1869)
+++ trunk/sql/Pg-database.sql	2007-11-16 00:38:52 UTC (rev 1870)
@@ -134,8 +134,8 @@
   line_one text check (line_one ~ '[[:alnum:]_]') NOT NULL,
   line_two text,
   line_three text,
-  city text check (city '[[:alnum:]_]') NOT NULL,
-  state text check(state '[[:alnum:]_]' NOT NULL),
+  city text check (city ~ '[[:alnum:]_]') NOT NULL,
+  state text check(state ~ '[[:alnum:]_]') NOT NULL,
   country_id integer not null REFERENCES country(id),
   mail_code text not null check (mail_code ~ '[[:alnum:]_]'),
   created date not null,


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.