Skip to content
GlueSQL
Conditional
Search
GlueSQL
Introduction
Getting Started
Getting Started
Rust
JavaScript (Web Browser)
Node.js
Command-Line Interface
SQL Syntax
SQL Syntax
Introduction
Statements
Statements
Querying
Querying
WHERE
JOIN
LIMIT & OFFSET
Aggregation
Schemaless Data
Data definition
Data definition
CREATE TABLE
DROP TABLE
CREATE INDEX
DROP INDEX
ALTER TABLE
Data manipulation
Data manipulation
INSERT
UPDATE
DELETE
Transaction
Metadata
Metadata
SHOW TABLES
Data Dictionary
Data types
Data types
BOOLEAN
Integer Types
FLOAT
TEXT
DECIMAL
DATE
TIMESTAMP
TIME
INTERVAL
LIST
MAP
BYTEA
INET
UUID
Functions
Functions
Text
Text
ASCII
CHR
CONCAT
CONCAT_WS
FIND_IDX
INITCAP
LEFT
LOWER
LPAD
LTRIM
MD5
POSITION
REPEAT
REVERSE
RIGHT
RPAD
RTRIM
SUBSTR
TRIM
UPPER
Math
Math
ABS
ACOS
ASIN
ATAN
CEIL
COS
DEGREES
DIV
EXP
FLOOR
GCD
LCM
LN
LOG
LOG10
LOG2
MOD
PI
POWER
RADIANS
RAND
ROUND
SIGN
SIN
SQRT
TAN
TRUNC
Date & Time
Date & Time
ADD_MONTH
EXTRACT
FORMAT
LAST_DAY
NOW
TO_DATE
TO_TIME
TO_TIMESTAMP
List & Map
List & Map
APPEND
CONCAT
DEDUP
ENTRIES
IS_EMPTY
KEYS
LENGTH
PREPEND
SKIP
SLICE
SORT
SQL Function - "SPLICE"
TAKE
VALUES
Geometry
Geometry
CALC_DISTANCE
GET_X
GET_Y
POINT
Others
Others
CAST
COALESCE
GENERATE_UUID
GREATEST
IFNULL
AST Builder
AST Builder
Introduction
Statements
Statements
Querying
Querying
Fetching Data from Storage
Using Preloaded Data
Creating Derived Subqueries
Data Aggregation
Data Injection
Data Joining
Data Selection and Projection
Data Sorting and Limiting
Data Manipulation
Data Manipulation
Inserting Data
Updating Data
Deleting Data
Expressions
Expressions
Conditional
Conditional
On this page
Todo
Nested
Operator Based
Pattern Matching
Value Checking
Functions
Functions
Text
Text
Case Conversion
Character Conversion
Padding
Position and Indexing
Text Manipulation
Trimming
Math
Math
Basic Arithmetic
Conversion
Logarithmic and Exponential
Rounding
Special Mathematical
Trigonometric
Date & Time
Date & Time
Conversion
Current Date and Time
Date and Time Extraction
Formatting
List & Map
List & Map
List and Map Concatenation
List Manipulation
Geometry
Geometry
Coordinate Extraction
Distance Calculation
Point Creation
Others
Others
Null Handling
Type Conversion
Unique Identifier
Storages
Storages
Introduction
Supported Storages
Supported Storages
Composite Storage
CSV Storage
File Storage
Git Storage
IndexedDB Storage
JSON Storage
Memory Storage
Mongo Storage
Parquet Storage
Redb Storage
Redis Storage
Shared Memory Storage
Sled Storage
WebStorage (local & session)
Developing Custom Storages
Developing Custom Storages
Introduction
Understanding Store traits
Understanding Store traits
Store
StoreMut
AlterTable
Transaction
CustomFunction
CustomFunctionMut
Index
IndexMut
Metadata
Using the Test Suite
Archive
Archive
Articles
Articles
Articles
Breaking the Boundary between SQL and NoSQL Databases
GlueSQL - Revolutionizing Databases by Unifying Query Interfaces
Test-Driven Documentation - Automating User Manual Creation in GlueSQL
Releases
Releases
Releases
Release v0.14
Release v0.15
On this page
Todo
Introduction
AST Builder
Expressions
Conditional
¶
Todo
¶
- CASE: Returns a value on a condition.