检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 gaussdb=# CREATE TABLE t1_compfoo(a int, b compfoo); gaussdb=# CREATE TABLE t2_compfoo(a int, b compfoo); -- Change the owner of the user-defined type compfoo1 to usr1. gaussdb=# CREATE USER usr1 PASSWORD '********'; Delete
into dest; EXECUTE IMMEDIATE PSV_SQL1 into copyto; DBE_LOB.WRITE(dest, amount, 1, source); DBE_LOB.WRITE_APPEND(dest, amount, source); DBE_LOB.ERASE(dest, a, 1); DBE_OUTPUT.PRINT_LINE(a); DBE_LOB.COPY(copyto, dest, amount, 10, 1); perform DBE_LOB.CLOSE(dest); RETURN; END; / -- Delete
FROM XMLTEST; DELETE 2 gaussdb=# INSERT INTO xmltest VALUES (1, '<?
Tobias | 30 | 2006-11-15 00:00:00 | yq1 | 30 | 2003-05-18 00:00:00 | yq2 | 30 | 2003-05-18 00:00:00 2007-12-10 00:00:00 | yq3 | 30 | 2003-05-18 00:00:00 (13 rows) -- Delete
The prototype of the PKG_UTIL.UTILITY_FORMAT_CALL_STACK function is as follows: 1 2 PKG_UTIL.UTILITY_FORMAT_CALL_STACK() RETURN TEXT Example: -- Delete a schema. drop schema if exists pkg_var_test cascade; -- Create a schema named pkg_var_test. create schema pkg_var_test; -- Set
Keywords such as BEGIN, BY, CLOSE, CURSOR, DECLARE, DELETE, EXECUTE, FUNCTION, IF, IMMEDIATE, INSERT, LOOP, MOVE, OF, REF, RELEASE, RETURN, SAVEPOINT, STRICT, TYPE, and UPDATE without double quotation marks cannot be used as variable names.
Keywords such as BEGIN, BY, CLOSE, CURSOR, DECLARE, DELETE, EXECUTE, FUNCTION, IF, IMMEDIATE, INSERT, LOOP, MOVE, OF, REF, RELEASE, RETURN, SAVEPOINT, STRICT, TYPE, and UPDATE without double quotation marks cannot be used as variable names.
The following functions are affected: To delete the base column of a generated column, you need to delete the corresponding generated column first. The SET NULL, SET DEFAULT, and CASCADE keywords cannot be associated with the ON UPDATED and ON DELETE actions.
The multinode hint can be added after the select, insert, update, delete, and merge keywords. Setting method: This parameter is a USERSET parameter and cannot be set using gs_guc.
GTM Wait event gtm drop sequence Waits for GTM to delete a sequence. GTM Wait event gtm rename sequence Waits for GTM to rename a sequence. GTM LWLock event GTMHostInfoLock Protects GTM information.
CALL proc_raw(); 6 proc_raw ---------- (1 row) -- Delete the stored procedure. DROP PROCEDURE proc_raw; DROP PROCEDURE DECLARE v_raw RAW; v_double BINARY_DOUBLE; v_float FLOAT4; v_numeric NUMERIC; v_nvarchar2 NVARCHAR2; BEGIN -- Perform bitwise AND calculation on RAW values.
If this parameter is not supported, delete it from the configuration file first before proceeding with the upgrade. Parent topic: Connection and Authentication
--------------+----------------------------+----------------- now | 2023-02-27 11:38:13 | 2023-02-27 11:38:13.032815 | 11:38:13.032815 today | 2023-02-27 00:00:00 | 2023-02-27 00:00:00 | tomorrow | 2023-02-28 00:00:00 | 2023-02-28 00:00:00 | (3 rows) -- 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
\nEND ldp_pkg1; \n /"} (1 row) Delete the logical replication slot slot1 and package ldp_pkg1. 1 2 3 4 5 6 7 8 9 gaussdb=# SELECT * FROM pg_drop_replication_slot('slot1'); pg_drop_replication_slot -------------------------- (1 row) gaussdb=# DROP PACKAGE ldp_pkg1; NOTICE: drop
Return type: timestamptz pg_stat_set_last_data_changed_time(oid) Description: Manually changes the time when INSERT, UPDATE, DELETE, or EXCHANGE/TRUNCATE/DROP PARTITION was last performed.
Delete the table and restore the environment. */ RETURN_IF_NOT_SUCCESS(execute_cmd(sql_drop)); RETURN_IF_NOT_SUCCESS(commit_exec()); end_unit_test(); } In the preceding example, the number column is defined.
\nEND ldp_pkg1; \n /"} (1 row) Delete the logical replication slot slot1 and package ldp_pkg1. 1 2 3 4 5 6 7 8 9 db1=> SELECT * FROM pg_drop_replication_slot('slot1'); pg_drop_replication_slot -------------------------- (1 row) gaussdb=# DROP PACKAGE ldp_pkg1; NOTICE: drop cascades
Delete the table and restore the environment. */ RETURN_IF_NOT_SUCCESS(execute_cmd(sql_drop)); RETURN_IF_NOT_SUCCESS(commit_exec()); end_unit_test(); } In the preceding example, the number column is defined.
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
