Zen

Source string Source string

164/10000 · 164
English Actions
If the function is called more than once in a query, it returns the same result until the query completes, unless a yield has occurred. On yield, the value returned by NOW() is changing.
tarantool> select now(), now(), now()
---
- metadata:
- name: COLUMN_1
type: datetime
- name: COLUMN_2
type: datetime
- name: COLUMN_3
type: datetime
rows:
- ['2022-07-20T19:02:02.010812282+0300', '2022-07-20T19:02:02.010812282+0300', '2022-07-20T19:02:02.010812282+0300']
...
NULLIF
:samp:`NULLIF(expression-1, expression-2)`
Return *expression-1* if *expression-1* <> *expression-2*, otherwise return NULL.
``NULLIF('a', 'A')`` is 'a'.
``NULLIF(1.00, 1)`` is NULL.
Before :doc:`/release/2.10.4`, the type of the result was always ``SCALAR``. Since :doc:`/release/2.10.4`, the result of ``NULLIF`` matches the type of the first argument. If the first argument is the ``NULL`` literal, then the result has the ``SCALAR`` type.
POSITION
:samp:`POSITION({expression-1}, {expression-2})`
Return the position of expression-1 within expression-2, or return 0 if expression-1 does not appear within expression-2. The data types of the expressions must be either STRING or VARBINARY. If the expressions have data type STRING, then the result is the character position. If the expressions have data type VARBINARY, then the result is the byte position.
Short example: ``POSITION('C', 'ABC')`` is 3
Long example: The UTF-8 encoding for the Latin letter A is hexadecimal 41; the UTF-8 encoding for the Cyrillic letter Д is hexadecimal D094 -- you can confirm this by saying SELECT HEX('ДA'); and seeing that the result is 'D09441'. If you now execute ``SELECT POSITION('A', 'ДA');`` the result will be 2, because 'A' is the second character in the string. However, if you now execute ``SELECT POSITION(X'41', X'D09441');`` the result will be 3, because X'41' is the third byte in the byte sequence.
PRINTF
:samp:`PRINTF(string-expression [, expression ...])`
Return a string formatted according to the rules of the C ``sprintf()`` function, where ``%d%s`` means the next two arguments are a numeric and a string, and so on.
If an argument is missing or is NULL, it becomes:
'0' if the format requires an integer,
'0.0' if the format requires a numeric with a decimal point,
'' if the format requires a string.
Example: ``PRINTF('%da', 5)`` is '5a'.
QUOTE
:samp:`QUOTE(string-argument)`
Return a string with enclosing quotes if necessary, and with quotes inside the enclosing quotes if necessary. This function is useful for creating strings which are part of SQL statements, because of SQL's rules that string literals are enclosed by single quotes, and single quotes inside such strings are shown as two single quotes in a row.
Starting with Tarantool version 2.10, arguments with numeric data types are returned without change.
Example: ``QUOTE('a')`` is ``'a'``. ``QUOTE(5)`` is ``5``.
RAISE
:samp:`RAISE(FAIL, {error-message})`
This may only be used within a triggered statement. See also :ref:`Trigger Activation <sql_trigger_activation>`.
RANDOM
Syntax: :samp:`RANDOM()`

Loading…

User avatar None

New source string

testing_project / Documentation: reference/reference_sql/sql_statements_and_clauses — English

Return a string formatted according to the rules of the C ``sprintf()`` function, where ``%d%s`` means the next two arguments are a numeric and a string, and so on.
a year ago
Browse all string changes

Things to check

Multiple unnamed variables

There are multiple unnamed variables in the string, making it impossible for translators to reorder them

Reset

Glossary

English English
No related strings found in the glossary.

String information

Flags
python-format, read-only
String age
a year ago
Last updated
a year ago
Source string age
a year ago
Translation file
string 838