- 필수 기능
- 앱 내
- 서비스 관리
- 인프라스트럭처
- 애플리케이션 성능
- 디지털 경험
- 소프트웨어 제공
- 보안
- 로그 관리
- 관리
- 인프라스트럭처
- ci
- containers
- csm
- ndm
- otel_guides
- overview
- slos
- synthetics
- tests
- 워크플로
These functions return one value per row.
Name | Return type | Description |
---|---|---|
upper(text s) | text | Converts s to uppercase. |
Name | Return type | Description |
---|---|---|
lower(text s) | text | Converts s to lowercase. |
Name | Return type | Description |
---|---|---|
length(text s) | integer | Counts the number of characters in s. |
Name | Return type | Description |
---|---|---|
concat(expr x, y, …) | text | Concatenates the provided expressions. |
Name | Return type | Description |
---|---|---|
substr(expr s, numeric start, numeric numChars) | text | Returns a substring of s from start to a max of numChars, if provided. start is a 1-based index, so substr('hello', 2) returns 'ello' . If the start is less than 1, it is treated as if it were 1. The result is computed by taking the range of characters [start, start+numChars] , where if any value is less than 1, it is treated as 1. This means substr('hello', -2, 4) returns 'h' . |
Name | Return type | Description |
---|---|---|
replace(text s, text from, text to) | text | Replaces all occurrences in s of substring from with substring to. |
Name | Return type | Description |
---|---|---|
regexp_replace(text s, text pattern, text replacement) | text | Replace substrings in s that match the POSIX regular expression pattern with the replacement. Supports Go’s regular expression syntax. |
Name | Return type | Description |
---|---|---|
abs(numeric n) | integer | Returns the absolute value of n. |
Name | Return type | Description |
---|---|---|
round(numeric n, [s]) | numeric | Round n to s decimal places. |
Name | Return type | Description |
---|---|---|
mod(numeric x, numeric y) | integer | Returns the remainder of x / y . |
Name | Return type | Description |
---|---|---|
floor(numeric n) | numeric | Returns the nearest integer that is less than or equal to n. |
Name | Return type | Description |
---|---|---|
ceil(numeric n) | numeric | Returns the nearest integer that is greater than or equal to n. |
Name | Return type | Description |
---|---|---|
power(numeric n, numeric s) | numeric | Raises n to the s power. |
Name | Return type | Description |
---|---|---|
ln(numeric n) | numeric | Calculates the natural logarithm of n. |
Name | Return type | Description |
---|---|---|
sqrt(numeric n) | numeric | Calculates the square root of n. |
Name | Return type | Description |
---|---|---|
date_trunc(string precision, timestamp t) | timestamp | Truncates the timestamp to the chosen precision (“second”, “minute”, “hour”, “day”, “week”, “month”, or “year”). |
Name | Return type | Description |
---|---|---|
coalesce(expr x, y, …) | variable | Returns the first non-null expression. |
Name | Return type | Description |
---|---|---|
nullif(expr x, expr y) | variable | Returns NULL if both arguments are equal. Otherwise, returns x. |