Search for a command to run...
Articles tagged with #opengauss
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...
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...
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...
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...
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...
define view ⚫ A view is a virtual table derived from one or several basic tables, which can be used to control user access to data. The SQL statements involved are shown in the following table. ⚫ Description: The view is different from the basic ...