Changes between Version 1 and Version 2 of PostGreSQL

Timestamp:

Feb 17, 2011, 4:32:19 PM (13 years ago)

Author:

fknauft

Comment:

--

PostGreSQL

@@ -2 +2 @@
 
 * Editing Values in a complete Column:
+
   update mpdl.songy_tiang_zh_1637 set source_link = overlay(source_link placing 'http://echo.mpiwg-berlin.mpg.de/ECHOdocuView' from 1 for 48)
+
+* Adding new Views:
+
+CREATE OR REPLACE VIEW tiangong_kaiwu_chap12_oilfat AS 
+ SELECT *  FROM mpdl.songy_tiang_zh_1637
+  WHERE CAST(mpdl.songy_tiang_zh_1637.page AS numeric) >= 297 AND CAST(mpdl.songy_tiang_zh_1637.page AS numeric) <= 310;
+
+ALTER TABLE  tiangong_kaiwu_chap12_oilfat OWNER TO postgres;
+
+Insert into gis_table_meta_rows values
+(DEFAULT,'tiangong_kaiwu_chap12_oilfat','gis_id_point','gis_id'),
+(DEFAULT,'tiangong_kaiwu_chap12_oilfat','latitude','coord_lat'),
+(DEFAULT,'tiangong_kaiwu_chap12_oilfat','longitude','coord_lon');
+
+Insert into gis_table_meta values
+(DEFAULT,'postgres','mpdl','Song Yingxing: Tiangong Kaiwu, Chapt. 12, Oils and Fats','tiangong_kaiwu_chap12_oilfat','2011-02-17','2011-02-17');