Warning: Can't synchronize with repository "(default)" (Unsupported version control system "svn": No module named svn). Look in the Trac log for more information.

Changes between Version 2 and Version 3 of ViewsInSqlObject


Ignore:
Timestamp:
03/05/06 23:37:42 (13 years ago)
Author:
godoy
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ViewsInSqlObject

    v2 v3  
    5757 
    5858{{{ 
    59 CREATE VIEW myView AS SELECT table1.id::text || '.'::text || table2.id::text || '.'::text || table3.id::text as id, table1.col1, table2.col2, table3.col3 FROM table1, table2, table3 WHERE table1.something  = table2.otherthing AND table1.anotherthing = table3.yetanotherthing; 
     59CREATE VIEW myView AS  
     60       SELECT table1.id::text || '.'::text || table2.id::text || '.'::text || table3.id::text as id,  
     61              table1.col1, table2.col2, table3.col3  
     62       FROM table1, table2, table3  
     63       WHERE table1.something  = table2.otherthing AND table1.anotherthing = table3.yetanotherthing; 
    6064}}} 
    6165