检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Delete the table and restore the environment. */ RETURN_IF_NOT_SUCCESS(execute_cmd(sql_drop)); end_unit_test(); } In the preceding example, the number column is defined.
Delete the table and restore the environment. */ RETURN_IF_NOT_SUCCESS(execute_cmd(sql_drop)); end_unit_test(); } In the example, the number column is defined.
Delete the table and restore the environment. */ RETURN_IF_NOT_SUCCESS(execute_cmd(sql_drop)); end_unit_test(); } In the example, the number column is defined.
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
INTEGER) IMMUTABLE; -- Rename the func_add_sql2 function to add_two_number. gaussdb=# ALTER FUNCTION func_add_sql2(INTEGER, INTEGER) RENAME TO add_two_number; -- Change the owner of function add_two_number to omm. gaussdb=# ALTER FUNCTION omm(INTEGER, INTEGER) OWNER TO omm; -- Delete
If a name contains double quotation marks, the double quotation marks are deleted. Otherwise, the name becomes uppercase letters.
useoperatoradmin boolean Specifies whether the user is an OPRADMIN. t (true): yes. f (false): no. usepolicyadmin boolean Specifies whether the user is a POLADMIN. t (true): yes. f (false): no. get_instr_sql_count_info() Description: Provides the count of SELECT, UPDATE, INSERT, DELETE
HypoIndexLock Used to create, delete and reset the virtual index by the lightweight lock. XGBoostLibLock Used by DB4AI to call the XGBoost library. DropArchiveSlotLock Used to protect the concurrent sequence of deleting the archive slot.
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
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: Two parameters are entered.
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: Two parameters are entered.
HIRE_DATE DATE, employment_ID VARCHAR2(10), SALARY NUMBER(8,2), COMMISSION_PCT NUMBER(2,2), MANAGER_ID NUMBER(6), section_ID NUMBER(4) ) SERVER gsmpp_server OPTIONS (location 'file:///output_data/', format 'csv', delimiter '|', header 'on') WRITE ONLY; -- 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
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.
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.
ignore_extra_data), and headers included (header). openGauss=# COPY tpcds.ship_mode_t1 FROM '/home/omm/ds_ship_mode.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
v_info,v_in,v_offset); -- Output the result. dbe_output.print_line('id:'|| v_id || ' info:' || v_info); end loop; -- Close the cursor. dbe_sql.sql_unregister_context(context_id); end; / -- Call the stored procedure. openGauss=# call pro_dbe_sql_all_02(HEXTORAW('DEADBEEF'),0,1); -- Delete
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.
The following \set meta-command of gsql can be used to set a variable: \set varname value To delete the variables set by the \set command, run the following command: \unset varname NOTE: A variable is a simple name-value pair. The value can be any characters in any length.
The following \set meta-command of gsql can be used to set a variable: \set varname value To delete the variables set by the \set command, run the following command: \unset varname NOTE: A variable is a simple name-value pair. The value can be any characters in any length.
