@leo001
databsae
Oct 18, 2022 · 1 min read · to_char(numeric/smallint/integer/bigint/double precision/real[, fmt]) Description: Convert an integer or floating point value to a string in the specified format. The optional parameter fmt can be of the following categories: decimal characters, "gro...
Join discussionOct 18, 2022 · 1 min read · to_char(datetime/interval [, fmt]) Description: Convert a DATETIME or INTERVAL value of type DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE or TIMESTAMP WITH LOCAL TIME ZONE to TEXT type according to the format specified by fmt. The optional parameter fmt...
Join discussionOct 13, 2022 · 2 min read · db4ai_predict_by_bool (text, VARIADIC "any") Description: Get the model whose return value is Boolean for model inference task. This function is an internal call function. It is recommended to use the syntax PREDICT BY directly for inference tasks. P...
Join discussionOct 13, 2022 · 1 min read · pg_gtt_attached_pid(relOid) Description: Displays all thread pids that are using the specified global temporary table. Parameters: OID of the global temporary table. Return value type: record Example: copy code openGauss=# select * from pg_gtt_attach...
Join discussionOct 10, 2022 · 3 min read · define sequence ⚫ The sequence can generate a set of equally spaced values, which can be incremented automatically, mainly used for the primary key of the table. The SQL statements involved are shown in the table below. Create a sequence ⚫ Function...
Join discussion