检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Return type: varchar2(16) analyze_tgtype_for_event(n smallint) Description: Parses pg_trigger.tgtype, parses n by bit, and returns one or more of insert, update, delete, and truncate. Return type: varchar2(246) nanvl(n2, n1) Description: The input includes two parameters.
t1 "_REMOTE_TABLE_QUERY_" (cost=0.00..0.00 rows=20 width=12) Node/s: All datanodes -> Hash (cost=0.00..0.00 rows=20 width=12) -> Data Node Scan on t "_REMOTE_TABLE_QUERY_" (cost=0.00..0.00 rows=20 width=12) Node/s: All datanodes (7 rows) Delete
Return type: record pg_stat_get_sql_count() Description: Provides the counts of the SELECT, UPDATE, INSERT, DELETE, and MERGE INTO statements executed on the current node.
If it does, copy its data elsewhere, delete it, and call the copy_error_log_create() function to create the table. For details about columns in the public.pgxc_copy_error_log table, see Table 1.
create table tab_2(col2 char(3)); gaussdb=# insert into tab_2 values(' '); gaussdb=# insert into tab_1 select col2 from tab_2; gaussdb=# select * from tab_1 where col1 is null; col1 ------ (1 row) gaussdb=# select * from tab_1 where col1=' '; col1 ------ (0 rows) gaussdb=# delete
date_lt_timestamp date_lt_timestamptz date_mi date_mi_interval date_mii date_ne date_ne_timestamp date_ne_timestamptz date_out date_pl_interval date_pli date_recv date_send date_smaller date_sortsupport daterange_canonical daterange_subdiff datetime_pl datetimetz_pl dcbrt decode defined degrees delete
tab_2(col2 char(3)); openGauss=# insert into tab_2 values(' '); openGauss=# insert into tab_1 select col2 from tab_2; openGauss=# select * from tab_1 where col1 is null; col1 ------ (1 row) openGauss=# select * from tab_1 where col1=' '; col1 ------ (0 rows) openGauss=# delete
Only simple DELETE statements are supported. For example: DELETE FROM t1 WHERE c1 = ? and c2 = 10; Columns c1 and c2 are index columns, which can be followed by constants or parameters. Only simple UPDATE statements are supported. For example: UPDATE t1 SET c3 = c3+?
datetime_typ_tab; -- Create a table. gaussdb_m=# CREATE TABLE year_typ_tab(col1 year, col2 year(4)); -- Insert data. gaussdb_m=# INSERT INTO year_typ_tab VALUES ('2023', now()); -- View the data. gaussdb_m=# SELECT * FROM year_typ_tab; col1 | col2 ------+------ 2023 | 2023 (1 row) -- Delete
datetime_typ_tab; -- Create a table. gaussdb_m=# CREATE TABLE year_typ_tab(col1 year, col2 year(4)); -- Insert data. gaussdb_m=# INSERT INTO year_typ_tab VALUES ('2023', now()); -- View the data. gaussdb_m=# SELECT * FROM year_typ_tab; col1 | col2 ------+------ 2023 | 2023 (1 row) -- Delete
SM_CARRIER(61,20), SM_CONTRACT(82,20)) header; gaussdb=# COPY tpcds.ship_mode_t1 FROM '/home/omm/ds_ship_mode_fixed.dat' FIXED FORMATTER(SM_SHIP_MODE_SK(0, 2), SM_SHIP_MODE_ID(2,16), SM_TYPE(18,30), SM_CODE(50,10), SM_CARRIER(61,20), SM_CONTRACT(82,20)) header ignore_extra_data; -- Delete
create table tab_2(col2 char(3)); gaussdb=# insert into tab_2 values(' '); gaussdb=# insert into tab_1 select col2 from tab_2; gaussdb=# select * from tab_1 where col1 is null; col1 ------ (1 row) gaussdb=# select * from tab_1 where col1=' '; col1 ------ (0 rows) gaussdb=# delete
Oracle Database: The return value is the number of affected rows for INSERT, UPDATE, and DELETE statements and is meaningless for other statements. 17 EXECUTE_AND_FETCH Function RUN_AND_NEXT Function - 18 FETCH_ROWS Function NEXT_ROW Function - 19 GET_NEXT_RESULT Procedures Not supported
Oracle Database: The return value is the number of affected rows for INSERT, UPDATE, and DELETE statements and is meaningless for other statements. 17 EXECUTE_AND_FETCH Function RUN_AND_NEXT Function - 18 FETCH_ROWS Function NEXT_ROW Function - 19 GET_NEXT_RESULT Procedures Not supported
If the table is not a user table, migrate data to the corresponding table in the pg_catalog schema and delete the table in the original public schema.
gaussdb_m gaussdb_m=# CREATE TABLE t1(id int DEFAULT 100, name varchar(20) DEFAULT 'tt'); gaussdb_m=# INSERT INTO t1 VALUES(1,'test'); -- Execute the query. gaussdb_m=# SELECT default(id), default(name) FROM t1; default | default ---------+--------- 100 | tt (1 row) -- Delete
If the table is not a user table, migrate data to the corresponding table in the pg_catalog schema and delete the table in the original public schema.
gaussdb_m gaussdb_m=# CREATE TABLE t1(id int DEFAULT 100, name varchar(20) DEFAULT 'tt'); gaussdb_m=# INSERT INTO t1 VALUES(1,'test'); -- Execute the query. gaussdb_m=# SELECT default(id), default(name) FROM t1; default | default ---------+--------- 100 | tt (1 row) -- Delete
create table tab_2(col2 char(3)); gaussdb=# insert into tab_2 values(' '); gaussdb=# insert into tab_1 select col2 from tab_2; gaussdb=# select * from tab_1 where col1 is null; col1 ------ (1 row) gaussdb=# select * from tab_1 where col1=' '; col1 ------ (0 rows) gaussdb=# delete
