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

[..hidden..]

Revision: 2552
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2552&view=rev
Author:   jfkw
Date:     2009-04-13 10:34:11 +0000 (Mon, 13 Apr 2009)

Log Message:
-----------
Correct Pg-database.sql string literal escaping in country code.

Fixes warning:

psql:/path/to/ledgersmb13/sql/Pg-database.sql:1280: WARNING:  nonstandard use of \' in a string literal
LINE 1: INSERT INTO country(short_name,name) VALUES ('CI','Cote D\'I...
                                                          ^
HINT:  Use '' to write quotes in strings, or use the escape string syntax (E'...').

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2009-04-13 05:45:43 UTC (rev 2551)
+++ trunk/sql/Pg-database.sql	2009-04-13 10:34:11 UTC (rev 2552)
@@ -1277,7 +1277,7 @@
 INSERT INTO country(short_name,name) VALUES ('CF','Central African Republic');
 INSERT INTO country(short_name,name) VALUES ('CG','Congo');
 INSERT INTO country(short_name,name) VALUES ('CH','Switzerland');
-INSERT INTO country(short_name,name) VALUES ('CI','Cote D\'Ivoire (Ivory Coast)');
+INSERT INTO country(short_name,name) VALUES ('CI','Cote D''Ivoire (Ivory Coast)');
 INSERT INTO country(short_name,name) VALUES ('CK','Cook Islands');
 INSERT INTO country(short_name,name) VALUES ('CL','Chile');
 INSERT INTO country(short_name,name) VALUES ('CM','Cameroon');


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