SF.net SVN: ledger-smb:[2243] branches/1.2/sql/Pg-database.sql

[..hidden..]

Revision: 2243
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2243&view=rev
Author:   einhverfr
Date:     2008-08-12 00:48:13 +0000 (Tue, 12 Aug 2008)

Log Message:
-----------
upper casing some SQL statements

Modified Paths:
--------------
    branches/1.2/sql/Pg-database.sql

Modified: branches/1.2/sql/Pg-database.sql
===================================================================
--- branches/1.2/sql/Pg-database.sql	2008-08-08 05:11:41 UTC (rev 2242)
+++ branches/1.2/sql/Pg-database.sql	2008-08-12 00:48:13 UTC (rev 2243)
@@ -578,7 +578,7 @@
 );
 
 
-insert into transactions (id, table_name) SELECT id, 'ap' FROM ap;
+INSERT INTO transactions (id, table_name) SELECT id, 'ap' FROM ap;
 
 CREATE RULE ap_id_track_i AS ON insert TO ap 
 DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'ap');
@@ -586,7 +586,7 @@
 CREATE RULE ap_id_track_u AS ON update TO ap 
 DO UPDATE transactions SET id = new.id WHERE id = old.id;
 
-insert into transactions (id, table_name) SELECT id, 'ar' FROM ap;
+INSERT INTO transactions (id, table_name) SELECT id, 'ar' FROM ap;
 
 CREATE RULE ar_id_track_i AS ON insert TO ar 
 DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'ar');


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