Sybase移植到PG的实践.pptx

Sybase移植到PG的实践;;;迁移评估;;;;;;;;;BEGIN select @time_1=getdate() GOTO A END PRINT @word A: PRINT @time_1;IF @a = 1 BEGIN select @time_2 = time_clock from p_info_list PRINT @word END;;;datediff() 1 select datediff(hh,2015‐06‐06 14:21:23,2015‐06‐07 12:20:23) 2 go ‐‐‐‐‐‐‐‐‐‐‐ 21 1 select datediff(ms20150607) 2 go ‐‐‐‐‐‐‐‐‐‐‐;;A: SELECT ... IF ... GOTO A INSERT ... RETURN;SELECT ... IF ... GOTO B INSERT ... B: RETURN;1 CREATE TABLE TEST_8(a1 CHAR(10)) 2 go 1 INSERT INTO TEST_8 SELECT A 2 go (1 row affected);postgres=# CREATE TABLE TEST_8(a1 CHAR(10)); CREATE TABLE postgres=