<!-- CANARY: REQ=REQ-DOCS-001; FEATURE="Docs"; ASPECT=Documentation; STATUS=TESTED; OWNER=docs; UPDATED=2026-01-28 -->
<h2 id="data-types-reference" class="position-relative d-flex align-items-center group">
<span>Data Types Reference</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="data-types-reference"
aria-haspopup="dialog"
aria-label="Share link: Data Types Reference">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h2><div id="headingShareModal" class="heading-share-modal" role="dialog" aria-modal="true" aria-labelledby="headingShareTitle" hidden>
<div class="hsm-dialog" role="document">
<div class="hsm-header">
<h2 id="headingShareTitle" class="h6 mb-0 fw-bold">Share this section</h2>
<button type="button" class="hsm-close" aria-label="Close">
<i class="fa-solid fa-xmark"></i>
</button>
</div>
<div class="hsm-body">
<label for="headingShareInput" class="form-label small text-muted mb-1 text-uppercase fw-bold" style="font-size: 0.7rem; letter-spacing: 0.5px;">Permalink</label>
<div class="input-group mb-4 hsm-url-group">
<input id="headingShareInput" type="text" class="form-control font-monospace" readonly aria-readonly="true" style="font-size: 0.85rem;" />
<button class="btn btn-primary hsm-copy" type="button" aria-label="Copy" title="Copy">
<i class="fa-duotone fa-clipboard" aria-hidden="true"></i>
</button>
</div>
<div class="small fw-bold mb-2 text-muted text-uppercase" style="font-size: 0.7rem; letter-spacing: 0.5px;">Share via</div>
<div class="hsm-share-grid">
<a id="share-twitter" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer">
<i class="fa-brands fa-twitter me-2"></i>Twitter
</a>
<a id="share-linkedin" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer">
<i class="fa-brands fa-linkedin me-2"></i>LinkedIn
</a>
<a id="share-facebook" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer">
<i class="fa-brands fa-facebook me-2"></i>Facebook
</a>
</div>
</div>
</div>
</div>
<style>
.heading-share-modal {
position: fixed;
inset: 0;
display: flex;
justify-content: center;
align-items: center;
background: rgba(0, 0, 0, 0.6);
z-index: 1050;
padding: 1rem;
backdrop-filter: blur(4px);
-webkit-backdrop-filter: blur(4px);
}
.heading-share-modal[hidden] { display: none !important; }
.hsm-dialog {
max-width: 420px;
width: 100%;
background: var(--bs-body-bg, #fff);
color: var(--bs-body-color, #212529);
border: 1px solid var(--bs-border-color, rgba(0,0,0,0.1));
border-radius: 1rem;
box-shadow: 0 25px 50px -12px rgba(0, 0, 0, 0.25);
overflow: hidden;
animation: hsm-fade-in 0.2s ease-out;
}
@keyframes hsm-fade-in {
from { opacity: 0; transform: scale(0.95); }
to { opacity: 1; transform: scale(1); }
}
[data-bs-theme="dark"] .hsm-dialog {
background: #1e293b;
border-color: rgba(255,255,255,0.1);
color: #f8f9fa;
}
.hsm-header {
display: flex;
justify-content: space-between;
align-items: center;
padding: 1rem 1.5rem;
border-bottom: 1px solid var(--bs-border-color, rgba(0,0,0,0.1));
background: rgba(0,0,0,0.02);
}
[data-bs-theme="dark"] .hsm-header {
background: rgba(255,255,255,0.02);
border-color: rgba(255,255,255,0.1);
}
.hsm-close {
background: transparent;
border: none;
color: inherit;
opacity: 0.5;
padding: 0.25rem 0.5rem;
border-radius: 0.25rem;
font-size: 1.2rem;
line-height: 1;
transition: opacity 0.2s;
}
.hsm-close:hover {
opacity: 1;
}
.hsm-body {
padding: 1.5rem;
}
.hsm-url-group {
display: flex !important;
align-items: stretch;
}
.hsm-url-group .form-control {
flex: 1;
min-width: 0;
margin: 0;
background: var(--bs-secondary-bg, #f8f9fa);
border-color: var(--bs-border-color, #dee2e6);
border-top-right-radius: 0;
border-bottom-right-radius: 0;
height: 42px;
}
.hsm-url-group .btn {
flex: 0 0 auto;
margin: 0;
margin-left: -1px;
border-top-left-radius: 0;
border-bottom-left-radius: 0;
height: 42px;
display: flex;
align-items: center;
justify-content: center;
padding: 0 1.25rem;
z-index: 2;
}
[data-bs-theme="dark"] .hsm-url-group .form-control {
background: #0f172a;
border-color: #334155;
color: #e2e8f0;
}
.hsm-share-grid {
display: flex;
flex-direction: column;
gap: 0.5rem;
}
.hsm-share-grid .btn {
display: flex;
align-items: center;
justify-content: center;
font-size: 0.9rem;
padding: 0.6rem;
border-color: var(--bs-border-color);
width: 100%;
}
[data-bs-theme="dark"] .hsm-share-grid .btn {
color: #e2e8f0;
border-color: #475569;
}
[data-bs-theme="dark"] .hsm-share-grid .btn:hover {
background: #334155;
border-color: #cbd5e1;
}
</style>
<script>
(function(){
const modal = document.getElementById('headingShareModal');
if(!modal) return;
const input = modal.querySelector('#headingShareInput');
const copyBtn = modal.querySelector('.hsm-copy');
const twitter = modal.querySelector('#share-twitter');
const linkedin = modal.querySelector('#share-linkedin');
const facebook = modal.querySelector('#share-facebook');
const closeBtn = modal.querySelector('.hsm-close');
let lastFocus=null;
let trapBound=false;
function buildUrl(id){ return window.location.origin + window.location.pathname + '#' + id; }
function isOpen(){ return !modal.hasAttribute('hidden'); }
function hydrate(id){
const url=buildUrl(id);
input.value=url;
const enc=encodeURIComponent(url);
const text=encodeURIComponent(document.title);
if(twitter) twitter.href=`https://twitter.com/intent/tweet?url=${enc}&text=${text}`;
if(linkedin) linkedin.href=`https://www.linkedin.com/sharing/share-offsite/?url=${enc}`;
if(facebook) facebook.href=`https://www.facebook.com/sharer/sharer.php?u=${enc}`;
}
function openModal(id){
lastFocus=document.activeElement;
hydrate(id);
if(!isOpen()){
modal.removeAttribute('hidden');
}
requestAnimationFrame(()=>{ input.focus(); });
trapFocus();
}
function closeModal(){
if(!isOpen()) return;
modal.setAttribute('hidden','');
if(lastFocus && typeof lastFocus.focus==='function') lastFocus.focus();
}
function copyCurrent(){
try{ navigator.clipboard.writeText(input.value).then(()=>feedback(true),()=>fallback()); }
catch(e){ fallback(); }
}
function fallback(){ input.select(); try{ document.execCommand('copy'); feedback(true);}catch(e){ feedback(false);} }
function feedback(ok){ if(!copyBtn) return; const icon=copyBtn.querySelector('i'); if(!icon) return; const prev=copyBtn.getAttribute('data-prev')||icon.className; if(!copyBtn.getAttribute('data-prev')) copyBtn.setAttribute('data-prev',prev); icon.className= ok ? 'fa-duotone fa-clipboard-check':'fa-duotone fa-circle-exclamation'; setTimeout(()=>{ icon.className=prev; },1800); }
function handleShareClick(e){ e.preventDefault(); const btn=e.currentTarget; const id=btn.getAttribute('data-share-target'); if(id) openModal(id); }
function bindShareButtons(){
document.querySelectorAll('.h-share').forEach(btn=>{
if(!btn.dataset.hShareBound){ btn.addEventListener('click', handleShareClick); btn.dataset.hShareBound='1'; }
});
}
bindShareButtons();
if(document.readyState==='loading'){
document.addEventListener('DOMContentLoaded', bindShareButtons);
} else {
requestAnimationFrame(bindShareButtons);
}
document.addEventListener('click', function(e){
const shareBtn=e.target.closest && e.target.closest('.h-share');
if(shareBtn && !shareBtn.dataset.hShareBound){ handleShareClick.call(shareBtn, e); }
}, true);
document.addEventListener('click', e=>{
if(e.target===modal) closeModal();
if(e.target.closest && e.target.closest('.hsm-close')){ e.preventDefault(); closeModal(); }
if(copyBtn && (e.target===copyBtn || (e.target.closest && e.target.closest('.hsm-copy')))) { e.preventDefault(); copyCurrent(); }
});
document.addEventListener('keydown', e=>{ if(e.key==='Escape' && isOpen()) closeModal(); });
function trapFocus(){
if(trapBound) return;
trapBound=true;
modal.addEventListener('keydown', f=>{ if(f.key==='Tab' && isOpen()){ const focusable=[...modal.querySelectorAll('a[href],button,input,textarea,select,[tabindex]:not([tabindex="-1"])')].filter(el=>!el.hasAttribute('disabled')); if(!focusable.length) return; const first=focusable[0]; const last=focusable[focusable.length-1]; if(f.shiftKey && document.activeElement===first){ f.preventDefault(); last.focus(); } else if(!f.shiftKey && document.activeElement===last){ f.preventDefault(); first.focus(); } } });
}
if(closeBtn) closeBtn.addEventListener('click', e=>{ e.preventDefault(); closeModal(); });
})();
</script><p>Geode provides <strong>50+ specialized data types</strong> optimized for different use cases. This reference documents all types, their constructors, storage characteristics, and indexing recommendations.</p>
<h3 id="type-system-overview" class="position-relative d-flex align-items-center group">
<span>Type System Overview</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="type-system-overview"
aria-haspopup="dialog"
aria-label="Share link: Type System Overview">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="type-categories" class="position-relative d-flex align-items-center group">
<span>Type Categories</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="type-categories"
aria-haspopup="dialog"
aria-label="Share link: Type Categories">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><table>
<thead>
<tr>
<th>Category</th>
<th>Types</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><strong>Core</strong></td>
<td>NULL, BOOLEAN, INTEGER, FLOAT, STRING, BYTES</td>
<td>Fundamental types</td>
</tr>
<tr>
<td><strong>Numeric</strong></td>
<td>INT8-INT64, FLOAT32-FLOAT64, DECIMAL</td>
<td>Precision-specific numerics</td>
</tr>
<tr>
<td><strong>Temporal</strong></td>
<td>DATE, TIME, TIMESTAMP, ZONED_DATETIME, DURATION, INTERVAL</td>
<td>Date and time</td>
</tr>
<tr>
<td><strong>Collection</strong></td>
<td>LIST, MAP, SET</td>
<td>Compound types</td>
</tr>
<tr>
<td><strong>Vector</strong></td>
<td>VECTOR_F32, VECTOR_I32</td>
<td>ML embeddings</td>
</tr>
<tr>
<td><strong>Geographic</strong></td>
<td>LATLON, GEOPOINT, POLYGON</td>
<td>Spatial data</td>
</tr>
<tr>
<td><strong>Network</strong></td>
<td>IPADDR, SUBNET, MACADDR</td>
<td>Network addressing</td>
</tr>
<tr>
<td><strong>Structured</strong></td>
<td>JSON, JSONB</td>
<td>Semi-structured data</td>
</tr>
<tr>
<td><strong>Identity</strong></td>
<td>UUID, HASH</td>
<td>Unique identifiers</td>
</tr>
<tr>
<td><strong>Financial</strong></td>
<td>MONEY, BIGDECIMAL</td>
<td>Exact decimals</td>
</tr>
</tbody>
</table>
<hr>
<h3 id="core-types" class="position-relative d-flex align-items-center group">
<span>Core Types</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="core-types"
aria-haspopup="dialog"
aria-label="Share link: Core Types">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="null" class="position-relative d-flex align-items-center group">
<span>NULL</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="null"
aria-haspopup="dialog"
aria-label="Share link: NULL">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Represents the absence of a value.</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">NULL</span><span class="w"> </span><span class="py">literal</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">null</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">empty</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">NULL</span><span class="w"> </span><span class="py">check</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">p</span><span class="p">:</span><span class="nc">Person</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">p</span><span class="err">.</span><span class="py">middle_name</span><span class="w"> </span><span class="py">IS</span><span class="w"> </span><span class="py">NULL</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">p</span><span class="err">.</span><span class="py">name</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">NULL</span><span class="w"> </span><span class="py">coalescing</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">coalesce</span><span class="p">(</span><span class="py">p</span><span class="err">.</span><span class="py">nickname</span><span class="p">,</span><span class="w"> </span><span class="py">p</span><span class="err">.</span><span class="py">name</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">display_name</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><p><strong>Properties:</strong></p>
<ul>
<li>NULL propagates through most operations</li>
<li>NULL = NULL evaluates to NULL (not true)</li>
<li>Use <code>IS NULL</code> / <code>IS NOT NULL</code> for comparisons</li>
</ul>
<hr>
<h4 id="boolean" class="position-relative d-flex align-items-center group">
<span>BOOLEAN</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="boolean"
aria-haspopup="dialog"
aria-label="Share link: BOOLEAN">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Logical true/false values.</p>
<p><strong>Storage:</strong> 1 byte</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Literals</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="p">(:</span><span class="nc">User</span><span class="w"> </span><span class="p">{</span><span class="py">active</span><span class="p">:</span><span class="w"> </span><span class="nc">true</span><span class="p">,</span><span class="w"> </span><span class="py">verified</span><span class="p">:</span><span class="w"> </span><span class="nc">false</span><span class="p">})</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Boolean</span><span class="w"> </span><span class="py">operations</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">u</span><span class="p">:</span><span class="nc">User</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">u</span><span class="err">.</span><span class="py">active</span><span class="w"> </span><span class="py">AND</span><span class="w"> </span><span class="py">NOT</span><span class="w"> </span><span class="py">u</span><span class="err">.</span><span class="py">deleted</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">u</span><span class="err">.</span><span class="py">name</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Boolean</span><span class="w"> </span><span class="py">expressions</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">p</span><span class="p">:</span><span class="nc">Person</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">p</span><span class="err">.</span><span class="py">name</span><span class="p">,</span><span class="w"> </span><span class="py">p</span><span class="err">.</span><span class="py">age</span><span class="w"> </span><span class="err">></span><span class="p">=</span><span class="w"> </span><span class="py">18</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">is_adult</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><p><strong>Constructor:</strong></p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="py">toBoolean</span><span class="p">(</span><span class="err">'</span><span class="py">true</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">true</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">toBoolean</span><span class="p">(</span><span class="err">'</span><span class="py">false</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">false</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">toBoolean</span><span class="p">(</span><span class="py">1</span><span class="p">)</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">true</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">toBoolean</span><span class="p">(</span><span class="py">0</span><span class="p">)</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">false</span><span class="w">
</span></span></span></code></pre></div><hr>
<h4 id="integer" class="position-relative d-flex align-items-center group">
<span>INTEGER</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="integer"
aria-haspopup="dialog"
aria-label="Share link: INTEGER">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Whole numbers (default 64-bit signed).</p>
<p><strong>Storage:</strong> Variable (1-8 bytes based on value)</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Literals</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="p">(:</span><span class="nc">Product</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="nc">42</span><span class="p">,</span><span class="w"> </span><span class="py">stock</span><span class="p">:</span><span class="w"> </span><span class="nc">1000</span><span class="p">,</span><span class="w"> </span><span class="py">price_cents</span><span class="p">:</span><span class="w"> </span><span class="nc">1999</span><span class="p">})</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Arithmetic</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">10</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">5</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">3</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">result</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">25</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Integer</span><span class="w"> </span><span class="py">division</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">7</span><span class="w"> </span><span class="err">/</span><span class="w"> </span><span class="py">2</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">quotient</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">3</span><span class="w"> </span><span class="p">(</span><span class="py">truncates</span><span class="p">)</span><span class="w">
</span></span></span></code></pre></div><p><strong>Constructor:</strong></p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="py">toInteger</span><span class="p">(</span><span class="err">'</span><span class="py">42</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">42</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">toInteger</span><span class="p">(</span><span class="py">3</span><span class="mf">.7</span><span class="p">)</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">3</span><span class="w"> </span><span class="p">(</span><span class="py">truncates</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">toInteger</span><span class="p">(</span><span class="py">true</span><span class="p">)</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">1</span><span class="w">
</span></span></span></code></pre></div><p><strong>Range:</strong> -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807</p>
<hr>
<h4 id="float" class="position-relative d-flex align-items-center group">
<span>FLOAT</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="float"
aria-haspopup="dialog"
aria-label="Share link: FLOAT">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Floating-point numbers (IEEE 754 double precision).</p>
<p><strong>Storage:</strong> 8 bytes</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Literals</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="p">(:</span><span class="nc">Measurement</span><span class="w"> </span><span class="p">{</span><span class="py">value</span><span class="p">:</span><span class="w"> </span><span class="nc">3</span><span class="mf">.14159</span><span class="p">,</span><span class="w"> </span><span class="py">tolerance</span><span class="p">:</span><span class="w"> </span><span class="nc">0</span><span class="mf">.001</span><span class="p">})</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Scientific</span><span class="w"> </span><span class="py">notation</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">1</span><span class="mf">.5e10</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">large_number</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Arithmetic</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">7</span><span class="mf">.0</span><span class="w"> </span><span class="err">/</span><span class="w"> </span><span class="py">2</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">division</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">3</span><span class="mf">.5</span><span class="w">
</span></span></span></code></pre></div><p><strong>Constructor:</strong></p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="py">toFloat</span><span class="p">(</span><span class="err">'</span><span class="py">3</span><span class="mf">.14</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">3</span><span class="mf">.14</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">toFloat</span><span class="p">(</span><span class="py">42</span><span class="p">)</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">42</span><span class="mf">.0</span><span class="w">
</span></span></span></code></pre></div><p><strong>Special values:</strong> <code>Infinity</code>, <code>-Infinity</code>, <code>NaN</code></p>
<hr>
<h4 id="string" class="position-relative d-flex align-items-center group">
<span>STRING</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="string"
aria-haspopup="dialog"
aria-label="Share link: STRING">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>UTF-8 encoded text.</p>
<p><strong>Storage:</strong> Variable (length prefix + UTF-8 bytes)</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Literals</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="p">(:</span><span class="nc">Person</span><span class="w"> </span><span class="p">{</span><span class="py">name</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">Alice</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="py">bio</span><span class="p">:</span><span class="w"> </span><span class="s">"Software engineer"</span><span class="p">})</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="nc">Concatenation</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="err">'</span><span class="py">Hello</span><span class="err">'</span><span class="w"> </span><span class="p">||</span><span class="w"> </span><span class="err">'</span><span class="w"> </span><span class="err">'</span><span class="w"> </span><span class="p">||</span><span class="w"> </span><span class="err">'</span><span class="py">World</span><span class="err">'</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">greeting</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">String</span><span class="w"> </span><span class="py">functions</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">upper</span><span class="p">(</span><span class="err">'</span><span class="py">hello</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">uppercase</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="err">'</span><span class="py">HELLO</span><span class="err">'</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">substring</span><span class="p">(</span><span class="err">'</span><span class="py">hello</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="py">0</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">sub</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="err">'</span><span class="py">hel</span><span class="err">'</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">length</span><span class="p">(</span><span class="err">'</span><span class="py">hello</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">len</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">5</span><span class="w">
</span></span></span></code></pre></div><p><strong>Constructor:</strong></p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="py">toString</span><span class="p">(</span><span class="py">42</span><span class="p">)</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="err">'</span><span class="py">42</span><span class="err">'</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">toString</span><span class="p">(</span><span class="py">3</span><span class="mf">.14</span><span class="p">)</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="err">'</span><span class="py">3</span><span class="mf">.14</span><span class="err">'</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">toString</span><span class="p">(</span><span class="py">true</span><span class="p">)</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="err">'</span><span class="py">true</span><span class="err">'</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">toString</span><span class="p">(</span><span class="py">date</span><span class="p">(</span><span class="err">'</span><span class="py">2026</span><span class="err">-</span><span class="py">01</span><span class="err">-</span><span class="py">28</span><span class="err">'</span><span class="p">))</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="err">'</span><span class="py">2026</span><span class="err">-</span><span class="py">01</span><span class="err">-</span><span class="py">28</span><span class="err">'</span><span class="w">
</span></span></span></code></pre></div><p><strong>Escapes:</strong> <code>\n</code>, <code>\t</code>, <code>\\</code>, <code>\'</code>, <code>\"</code></p>
<hr>
<h4 id="bytes" class="position-relative d-flex align-items-center group">
<span>BYTES</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="bytes"
aria-haspopup="dialog"
aria-label="Share link: BYTES">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Raw binary data.</p>
<p><strong>Storage:</strong> Variable (length prefix + raw bytes)</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Hex</span><span class="w"> </span><span class="py">literal</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="p">(:</span><span class="nc">File</span><span class="w"> </span><span class="p">{</span><span class="py">data</span><span class="p">:</span><span class="w"> </span><span class="err">'\\</span><span class="nc">x48656c6c6f</span><span class="err">'</span><span class="p">::</span><span class="nc">bytea</span><span class="p">})</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="nc">Base64</span><span class="w"> </span><span class="p">(</span><span class="py">if</span><span class="w"> </span><span class="py">supported</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="p">(:</span><span class="nc">File</span><span class="w"> </span><span class="p">{</span><span class="py">data</span><span class="p">:</span><span class="w"> </span><span class="nc">base64_decode</span><span class="p">(</span><span class="err">'</span><span class="py">SGVsbG8</span><span class="p">=</span><span class="err">'</span><span class="p">)})</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Length</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">f</span><span class="p">:</span><span class="nc">File</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">length</span><span class="p">(</span><span class="py">f</span><span class="err">.</span><span class="py">data</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">bytes</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><p><strong>Constructor:</strong></p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">'\\</span><span class="py">x48656c6c6f</span><span class="err">'</span><span class="p">::</span><span class="nc">bytea</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="nc">Hex</span><span class="w"> </span><span class="py">encoding</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">bytes_from_hex</span><span class="p">(</span><span class="err">'</span><span class="py">48656c6c6f</span><span class="err">'</span><span class="p">)</span><span class="w">
</span></span></span></code></pre></div><hr>
<h3 id="numeric-types-precision-specific" class="position-relative d-flex align-items-center group">
<span>Numeric Types (Precision-Specific)</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="numeric-types-precision-specific"
aria-haspopup="dialog"
aria-label="Share link: Numeric Types (Precision-Specific)">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="integer-variants" class="position-relative d-flex align-items-center group">
<span>Integer Variants</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="integer-variants"
aria-haspopup="dialog"
aria-label="Share link: Integer Variants">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><table>
<thead>
<tr>
<th>Type</th>
<th>Storage</th>
<th>Range</th>
<th>Use Case</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>INT8</code></td>
<td>1 byte</td>
<td>-128 to 127</td>
<td>Small counters</td>
</tr>
<tr>
<td><code>INT16</code></td>
<td>2 bytes</td>
<td>-32,768 to 32,767</td>
<td>Medium counters</td>
</tr>
<tr>
<td><code>INT32</code></td>
<td>4 bytes</td>
<td>-2.1B to 2.1B</td>
<td>Default integer</td>
</tr>
<tr>
<td><code>INT64</code></td>
<td>8 bytes</td>
<td>-9.2Q to 9.2Q</td>
<td>Large IDs</td>
</tr>
</tbody>
</table>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Explicit</span><span class="w"> </span><span class="py">constructors</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">int8</span><span class="p">(</span><span class="py">127</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">i8</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">int16</span><span class="p">(</span><span class="py">32000</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">i16</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">int32</span><span class="p">(</span><span class="py">2000000</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">i32</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">int64</span><span class="p">(</span><span class="py">9000000000000</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">i64</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h4 id="float-variants" class="position-relative d-flex align-items-center group">
<span>Float Variants</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="float-variants"
aria-haspopup="dialog"
aria-label="Share link: Float Variants">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><table>
<thead>
<tr>
<th>Type</th>
<th>Storage</th>
<th>Precision</th>
<th>Use Case</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>FLOAT32</code></td>
<td>4 bytes</td>
<td>~7 digits</td>
<td>Approximate decimals</td>
</tr>
<tr>
<td><code>FLOAT64</code></td>
<td>8 bytes</td>
<td>~15 digits</td>
<td>High-precision decimals</td>
</tr>
</tbody>
</table>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="py">RETURN</span><span class="w"> </span><span class="py">float32</span><span class="p">(</span><span class="py">3</span><span class="mf">.14</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">f32</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">float64</span><span class="p">(</span><span class="py">3</span><span class="mf">.14159265358979</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">f64</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h4 id="decimal--bigdecimal" class="position-relative d-flex align-items-center group">
<span>DECIMAL / BIGDECIMAL</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="decimal--bigdecimal"
aria-haspopup="dialog"
aria-label="Share link: DECIMAL / BIGDECIMAL">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Arbitrary-precision decimal numbers.</p>
<p><strong>Storage:</strong> Variable</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Exact</span><span class="w"> </span><span class="py">decimal</span><span class="w"> </span><span class="py">arithmetic</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="p">(:</span><span class="nc">Account</span><span class="w"> </span><span class="p">{</span><span class="py">balance</span><span class="p">:</span><span class="w"> </span><span class="nc">decimal</span><span class="p">(</span><span class="err">'</span><span class="py">1234567</span><span class="mf">.89</span><span class="err">'</span><span class="p">)})</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">No</span><span class="w"> </span><span class="py">floating</span><span class="err">-</span><span class="py">point</span><span class="w"> </span><span class="py">errors</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">decimal</span><span class="p">(</span><span class="err">'</span><span class="py">0</span><span class="mf">.1</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">decimal</span><span class="p">(</span><span class="err">'</span><span class="py">0</span><span class="mf">.2</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">sum</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">0</span><span class="mf">.3</span><span class="w"> </span><span class="p">(</span><span class="py">exact</span><span class="p">)</span><span class="w">
</span></span></span></code></pre></div><p><strong>Constructor:</strong></p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="py">decimal</span><span class="p">(</span><span class="err">'</span><span class="py">123</span><span class="mf">.456</span><span class="err">'</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">decimal</span><span class="p">(</span><span class="err">'</span><span class="py">999999999999999999</span><span class="mf">.999999999999</span><span class="err">'</span><span class="p">)</span><span class="w">
</span></span></span></code></pre></div><p><strong>Use cases:</strong> Financial calculations, currency, exact arithmetic</p>
<hr>
<h3 id="temporal-types" class="position-relative d-flex align-items-center group">
<span>Temporal Types</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="temporal-types"
aria-haspopup="dialog"
aria-label="Share link: Temporal Types">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="date" class="position-relative d-flex align-items-center group">
<span>DATE</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="date"
aria-haspopup="dialog"
aria-label="Share link: DATE">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Calendar date (year, month, day).</p>
<p><strong>Storage:</strong> 4 bytes</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Constructor</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">date</span><span class="p">(</span><span class="err">'</span><span class="py">2026</span><span class="err">-</span><span class="py">01</span><span class="err">-</span><span class="py">28</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">d</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Current</span><span class="w"> </span><span class="py">date</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">date</span><span class="p">()</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">today</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Components</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">date</span><span class="p">(</span><span class="err">'</span><span class="py">2026</span><span class="err">-</span><span class="py">01</span><span class="err">-</span><span class="py">28</span><span class="err">'</span><span class="p">)</span><span class="err">.</span><span class="py">year</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">year</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">2026</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">date</span><span class="p">(</span><span class="err">'</span><span class="py">2026</span><span class="err">-</span><span class="py">01</span><span class="err">-</span><span class="py">28</span><span class="err">'</span><span class="p">)</span><span class="err">.</span><span class="py">month</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">month</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">1</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">date</span><span class="p">(</span><span class="err">'</span><span class="py">2026</span><span class="err">-</span><span class="py">01</span><span class="err">-</span><span class="py">28</span><span class="err">'</span><span class="p">)</span><span class="err">.</span><span class="py">day</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">day</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">28</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Arithmetic</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">date</span><span class="p">(</span><span class="err">'</span><span class="py">2026</span><span class="err">-</span><span class="py">01</span><span class="err">-</span><span class="py">28</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">duration</span><span class="p">(</span><span class="err">'</span><span class="py">P7D</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">next_week</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><p><strong>Format:</strong> ISO 8601 (<code>YYYY-MM-DD</code>)</p>
<hr>
<h4 id="time" class="position-relative d-flex align-items-center group">
<span>TIME</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="time"
aria-haspopup="dialog"
aria-label="Share link: TIME">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Time of day without timezone.</p>
<p><strong>Storage:</strong> 8 bytes (nanosecond precision)</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Constructor</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">time</span><span class="p">(</span><span class="err">'</span><span class="py">14</span><span class="p">:</span><span class="nc">30</span><span class="p">:</span><span class="nc">00</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">t</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">time</span><span class="p">(</span><span class="err">'</span><span class="py">14</span><span class="p">:</span><span class="nc">30</span><span class="p">:</span><span class="nc">00</span><span class="mf">.123456789</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">precise_time</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Components</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">time</span><span class="p">(</span><span class="err">'</span><span class="py">14</span><span class="p">:</span><span class="nc">30</span><span class="p">:</span><span class="nc">45</span><span class="err">'</span><span class="p">)</span><span class="err">.</span><span class="py">hour</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">hour</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">14</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">time</span><span class="p">(</span><span class="err">'</span><span class="py">14</span><span class="p">:</span><span class="nc">30</span><span class="p">:</span><span class="nc">45</span><span class="err">'</span><span class="p">)</span><span class="err">.</span><span class="py">minute</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">minute</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">30</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">time</span><span class="p">(</span><span class="err">'</span><span class="py">14</span><span class="p">:</span><span class="nc">30</span><span class="p">:</span><span class="nc">45</span><span class="err">'</span><span class="p">)</span><span class="err">.</span><span class="py">second</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">second</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">45</span><span class="w">
</span></span></span></code></pre></div><p><strong>Format:</strong> ISO 8601 (<code>HH:MM:SS[.nnnnnnnnn]</code>)</p>
<hr>
<h4 id="timestamp" class="position-relative d-flex align-items-center group">
<span>TIMESTAMP</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="timestamp"
aria-haspopup="dialog"
aria-label="Share link: TIMESTAMP">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Date and time with optional timezone.</p>
<p><strong>Storage:</strong> 12 bytes</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Constructor</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">timestamp</span><span class="p">(</span><span class="err">'</span><span class="py">2026</span><span class="err">-</span><span class="py">01</span><span class="err">-</span><span class="py">28T14</span><span class="p">:</span><span class="nc">30</span><span class="p">:</span><span class="nc">00Z</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">ts</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">timestamp</span><span class="p">(</span><span class="err">'</span><span class="py">2026</span><span class="err">-</span><span class="py">01</span><span class="err">-</span><span class="py">28T14</span><span class="p">:</span><span class="nc">30</span><span class="p">:</span><span class="nc">00</span><span class="err">-</span><span class="py">05</span><span class="p">:</span><span class="nc">00</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">ts_est</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Current</span><span class="w"> </span><span class="py">timestamp</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">timestamp</span><span class="p">()</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">now</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Arithmetic</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">e</span><span class="p">:</span><span class="nc">Event</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">e</span><span class="err">.</span><span class="py">created_at</span><span class="w"> </span><span class="err">></span><span class="w"> </span><span class="py">timestamp</span><span class="p">()</span><span class="w"> </span><span class="err">-</span><span class="w"> </span><span class="py">duration</span><span class="p">(</span><span class="err">'</span><span class="py">P30D</span><span class="err">'</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">e</span><span class="err">.</span><span class="py">name</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><p><strong>Format:</strong> ISO 8601 (<code>YYYY-MM-DDTHH:MM:SS[.nnn][Z|+HH:MM]</code>)</p>
<hr>
<h4 id="zoned_datetime" class="position-relative d-flex align-items-center group">
<span>ZONED_DATETIME</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="zoned_datetime"
aria-haspopup="dialog"
aria-label="Share link: ZONED_DATETIME">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Date and time with explicit timezone.</p>
<p><strong>Storage:</strong> 16 bytes</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Constructor</span><span class="w"> </span><span class="py">with</span><span class="w"> </span><span class="py">timezone</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">zoned_datetime</span><span class="p">(</span><span class="err">'</span><span class="py">2026</span><span class="err">-</span><span class="py">01</span><span class="err">-</span><span class="py">28T14</span><span class="p">:</span><span class="nc">30</span><span class="p">:</span><span class="nc">00</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="err">'</span><span class="py">America</span><span class="err">/</span><span class="py">New_York</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">zdt</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Timezone</span><span class="w"> </span><span class="py">conversion</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">zdt</span><span class="err">.</span><span class="py">in_timezone</span><span class="p">(</span><span class="err">'</span><span class="py">Europe</span><span class="err">/</span><span class="py">London</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">london_time</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><hr>
<h4 id="duration" class="position-relative d-flex align-items-center group">
<span>DURATION</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="duration"
aria-haspopup="dialog"
aria-label="Share link: DURATION">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Time span (ISO 8601 duration).</p>
<p><strong>Storage:</strong> 16 bytes</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Constructor</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">duration</span><span class="p">(</span><span class="err">'</span><span class="py">P7D</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="kd">on</span><span class="py">e_week</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">7</span><span class="w"> </span><span class="py">days</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">duration</span><span class="p">(</span><span class="err">'</span><span class="py">PT2H30M</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">two_half_hours</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">2</span><span class="w"> </span><span class="py">hours</span><span class="w"> </span><span class="py">30</span><span class="w"> </span><span class="py">minutes</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">duration</span><span class="p">(</span><span class="err">'</span><span class="py">P1Y2M3DT4H5M6S</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">complex</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">1</span><span class="w"> </span><span class="py">year</span><span class="p">,</span><span class="w"> </span><span class="py">2</span><span class="w"> </span><span class="py">months</span><span class="p">,</span><span class="w"> </span><span class="kd">...</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Components</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">duration</span><span class="p">(</span><span class="err">'</span><span class="py">P7D</span><span class="err">'</span><span class="p">)</span><span class="err">.</span><span class="py">days</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">days</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">7</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">duration</span><span class="p">(</span><span class="err">'</span><span class="py">PT2H30M</span><span class="err">'</span><span class="p">)</span><span class="err">.</span><span class="py">hours</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">hours</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">2</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">duration</span><span class="p">(</span><span class="err">'</span><span class="py">PT2H30M</span><span class="err">'</span><span class="p">)</span><span class="err">.</span><span class="py">minutes</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">mins</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">30</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Arithmetic</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">timestamp</span><span class="p">()</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">duration</span><span class="p">(</span><span class="err">'</span><span class="py">P7D</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">next_week</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">timestamp</span><span class="p">()</span><span class="w"> </span><span class="err">-</span><span class="w"> </span><span class="py">duration</span><span class="p">(</span><span class="err">'</span><span class="py">PT1H</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="kd">on</span><span class="py">e_hour_ago</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><p><strong>Format:</strong> ISO 8601 (<code>PnYnMnDTnHnMnS</code>)</p>
<hr>
<h4 id="interval" class="position-relative d-flex align-items-center group">
<span>INTERVAL</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="interval"
aria-haspopup="dialog"
aria-label="Share link: INTERVAL">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Time range for overlap queries.</p>
<p><strong>Storage:</strong> 24 bytes</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Constructor</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">interval</span><span class="p">(</span><span class="err">'</span><span class="p">[</span><span class="py">2026</span><span class="err">-</span><span class="py">01</span><span class="err">-</span><span class="py">01</span><span class="p">,</span><span class="w"> </span><span class="py">2026</span><span class="err">-</span><span class="py">01</span><span class="err">-</span><span class="py">31</span><span class="p">]</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">january</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Open</span><span class="err">/</span><span class="py">closed</span><span class="w"> </span><span class="py">bounds</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">interval</span><span class="p">(</span><span class="err">'</span><span class="p">[</span><span class="py">2026</span><span class="err">-</span><span class="py">01</span><span class="err">-</span><span class="py">01</span><span class="p">,</span><span class="w"> </span><span class="py">2026</span><span class="err">-</span><span class="py">02</span><span class="err">-</span><span class="py">01</span><span class="p">)</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">january_exclusive</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Overlap</span><span class="w"> </span><span class="kd">query</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="nc">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">e</span><span class="p">:</span><span class="nc">Event</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">e</span><span class="err">.</span><span class="py">duration</span><span class="w"> </span><span class="py">OVERLAPS</span><span class="w"> </span><span class="py">interval</span><span class="p">(</span><span class="err">'</span><span class="p">[</span><span class="py">2026</span><span class="err">-</span><span class="py">01</span><span class="err">-</span><span class="py">15</span><span class="p">,</span><span class="w"> </span><span class="py">2026</span><span class="err">-</span><span class="py">01</span><span class="err">-</span><span class="py">20</span><span class="p">]</span><span class="err">'</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">e</span><span class="err">.</span><span class="py">name</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Contains</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">e</span><span class="p">:</span><span class="nc">Event</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">interval_contains</span><span class="p">(</span><span class="py">e</span><span class="err">.</span><span class="py">duration</span><span class="p">,</span><span class="w"> </span><span class="py">timestamp</span><span class="p">(</span><span class="err">'</span><span class="py">2026</span><span class="err">-</span><span class="py">01</span><span class="err">-</span><span class="py">15T12</span><span class="p">:</span><span class="nc">00</span><span class="p">:</span><span class="nc">00Z</span><span class="err">'</span><span class="p">))</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">e</span><span class="err">.</span><span class="py">name</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><hr>
<h3 id="collection-types" class="position-relative d-flex align-items-center group">
<span>Collection Types</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="collection-types"
aria-haspopup="dialog"
aria-label="Share link: Collection Types">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="list" class="position-relative d-flex align-items-center group">
<span>LIST</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="list"
aria-haspopup="dialog"
aria-label="Share link: LIST">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Ordered collection of values.</p>
<p><strong>Storage:</strong> Variable</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Literal</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="p">[</span><span class="py">1</span><span class="p">,</span><span class="w"> </span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">,</span><span class="w"> </span><span class="py">4</span><span class="p">,</span><span class="w"> </span><span class="py">5</span><span class="p">]</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">numbers</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="p">[</span><span class="err">'</span><span class="py">apple</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="err">'</span><span class="py">banana</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="err">'</span><span class="py">cherry</span><span class="err">'</span><span class="p">]</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">fruits</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Indexing</span><span class="w"> </span><span class="p">(</span><span class="py">0</span><span class="err">-</span><span class="py">based</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="p">[</span><span class="py">10</span><span class="p">,</span><span class="w"> </span><span class="py">20</span><span class="p">,</span><span class="w"> </span><span class="py">30</span><span class="p">][</span><span class="py">0</span><span class="p">]</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">first</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">10</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="p">[</span><span class="py">10</span><span class="p">,</span><span class="w"> </span><span class="py">20</span><span class="p">,</span><span class="w"> </span><span class="py">30</span><span class="p">][</span><span class="py">2</span><span class="p">]</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">third</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">30</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="p">[</span><span class="py">10</span><span class="p">,</span><span class="w"> </span><span class="py">20</span><span class="p">,</span><span class="w"> </span><span class="py">30</span><span class="p">][</span><span class="err">-</span><span class="py">1</span><span class="p">]</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">last</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">30</span><span class="w"> </span><span class="p">(</span><span class="py">negative</span><span class="w"> </span><span class="py">indexing</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Slicing</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="p">[</span><span class="py">1</span><span class="p">,</span><span class="w"> </span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">,</span><span class="w"> </span><span class="py">4</span><span class="p">,</span><span class="w"> </span><span class="py">5</span><span class="p">][</span><span class="py">1</span><span class="err">.</span><span class="mf">.3</span><span class="p">]</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">slice</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="p">[</span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">]</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Functions</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">size</span><span class="p">([</span><span class="py">1</span><span class="p">,</span><span class="w"> </span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">])</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">len</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">3</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">head</span><span class="p">([</span><span class="py">1</span><span class="p">,</span><span class="w"> </span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">])</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">first</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">1</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">tail</span><span class="p">([</span><span class="py">1</span><span class="p">,</span><span class="w"> </span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">])</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">rest</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="p">[</span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">]</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">last</span><span class="p">([</span><span class="py">1</span><span class="p">,</span><span class="w"> </span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">])</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">final</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">3</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">List</span><span class="w"> </span><span class="py">comprehension</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="p">[</span><span class="py">x</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">2</span><span class="w"> </span><span class="py">FOR</span><span class="w"> </span><span class="py">x</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="p">[</span><span class="py">1</span><span class="p">,</span><span class="w"> </span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">]]</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">doubled</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="p">[</span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">4</span><span class="p">,</span><span class="w"> </span><span class="py">6</span><span class="p">]</span><span class="w">
</span></span></span></code></pre></div><hr>
<h4 id="map" class="position-relative d-flex align-items-center group">
<span>MAP</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="map"
aria-haspopup="dialog"
aria-label="Share link: MAP">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Key-value pairs (dictionary/object).</p>
<p><strong>Storage:</strong> Variable</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Literal</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="p">{</span><span class="py">name</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">Alice</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="py">age</span><span class="p">:</span><span class="w"> </span><span class="nc">30</span><span class="p">}</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">person</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Access</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="p">{</span><span class="py">name</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">Alice</span><span class="err">'</span><span class="p">}</span><span class="err">.</span><span class="py">name</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">name</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="err">'</span><span class="py">Alice</span><span class="err">'</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="p">{</span><span class="py">name</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">Alice</span><span class="err">'</span><span class="p">}[</span><span class="err">'</span><span class="py">name</span><span class="err">'</span><span class="p">]</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">name</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="err">'</span><span class="py">Alice</span><span class="err">'</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Keys</span><span class="w"> </span><span class="py">and</span><span class="w"> </span><span class="py">values</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">keys</span><span class="p">({</span><span class="py">a</span><span class="p">:</span><span class="w"> </span><span class="nc">1</span><span class="p">,</span><span class="w"> </span><span class="py">b</span><span class="p">:</span><span class="w"> </span><span class="nc">2</span><span class="p">})</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">k</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="p">[</span><span class="err">'</span><span class="py">a</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="err">'</span><span class="py">b</span><span class="err">'</span><span class="p">]</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">values</span><span class="p">({</span><span class="py">a</span><span class="p">:</span><span class="w"> </span><span class="nc">1</span><span class="p">,</span><span class="w"> </span><span class="py">b</span><span class="p">:</span><span class="w"> </span><span class="nc">2</span><span class="p">})</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">v</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="p">[</span><span class="py">1</span><span class="p">,</span><span class="w"> </span><span class="py">2</span><span class="p">]</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Merge</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="p">{</span><span class="py">a</span><span class="p">:</span><span class="w"> </span><span class="nc">1</span><span class="p">}</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="p">{</span><span class="py">b</span><span class="p">:</span><span class="w"> </span><span class="nc">2</span><span class="p">}</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">merged</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="p">{</span><span class="py">a</span><span class="p">:</span><span class="w"> </span><span class="nc">1</span><span class="p">,</span><span class="w"> </span><span class="py">b</span><span class="p">:</span><span class="w"> </span><span class="nc">2</span><span class="p">}</span><span class="w">
</span></span></span></code></pre></div><hr>
<h4 id="set" class="position-relative d-flex align-items-center group">
<span>SET</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="set"
aria-haspopup="dialog"
aria-label="Share link: SET">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Unordered collection of unique values.</p>
<p><strong>Storage:</strong> Variable</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Constructor</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">set</span><span class="p">([</span><span class="py">1</span><span class="p">,</span><span class="w"> </span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">])</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">unique</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="p">{</span><span class="py">1</span><span class="p">,</span><span class="w"> </span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">}</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Operations</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">set_union</span><span class="p">({</span><span class="py">1</span><span class="p">,</span><span class="w"> </span><span class="py">2</span><span class="p">},</span><span class="w"> </span><span class="p">{</span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">})</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="kd">union</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="p">{</span><span class="nc">1</span><span class="p">,</span><span class="w"> </span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">}</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">set_intersect</span><span class="p">({</span><span class="py">1</span><span class="p">,</span><span class="w"> </span><span class="py">2</span><span class="p">},</span><span class="w"> </span><span class="p">{</span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">})</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">inter</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="p">{</span><span class="py">2</span><span class="p">}</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">set_difference</span><span class="p">({</span><span class="py">1</span><span class="p">,</span><span class="w"> </span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">},</span><span class="w"> </span><span class="p">{</span><span class="py">2</span><span class="p">})</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">diff</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="p">{</span><span class="py">1</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">}</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Membership</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">2</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="p">{</span><span class="py">1</span><span class="p">,</span><span class="w"> </span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">}</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">contains</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">true</span><span class="w">
</span></span></span></code></pre></div><hr>
<h3 id="vector-types" class="position-relative d-flex align-items-center group">
<span>Vector Types</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="vector-types"
aria-haspopup="dialog"
aria-label="Share link: Vector Types">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="vector_f32" class="position-relative d-flex align-items-center group">
<span>VECTOR_F32</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="vector_f32"
aria-haspopup="dialog"
aria-label="Share link: VECTOR_F32">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>32-bit floating-point vector for ML embeddings.</p>
<p><strong>Storage:</strong> 4 bytes per dimension</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Constructor</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="err">'</span><span class="p">[</span><span class="py">0</span><span class="mf">.1</span><span class="p">,</span><span class="w"> </span><span class="py">0</span><span class="mf">.2</span><span class="p">,</span><span class="w"> </span><span class="py">0</span><span class="mf">.3</span><span class="p">,</span><span class="w"> </span><span class="py">0</span><span class="mf">.4</span><span class="p">]</span><span class="err">'</span><span class="p">::</span><span class="nc">vector_f32</span><span class="w"> </span><span class="nc">AS</span><span class="w"> </span><span class="py">v</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">From</span><span class="w"> </span><span class="py">array</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">vector_f32</span><span class="p">([</span><span class="py">0</span><span class="mf">.1</span><span class="p">,</span><span class="w"> </span><span class="py">0</span><span class="mf">.2</span><span class="p">,</span><span class="w"> </span><span class="py">0</span><span class="mf">.3</span><span class="p">,</span><span class="w"> </span><span class="py">0</span><span class="mf">.4</span><span class="p">])</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">v</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Distance</span><span class="w"> </span><span class="py">functions</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">vector_distance_l2</span><span class="p">(</span><span class="py">v1</span><span class="p">,</span><span class="w"> </span><span class="py">v2</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">euclidean</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">vector_distance_cosine</span><span class="p">(</span><span class="py">v1</span><span class="p">,</span><span class="w"> </span><span class="py">v2</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">cosine</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">vector_distance_dot</span><span class="p">(</span><span class="py">v1</span><span class="p">,</span><span class="w"> </span><span class="py">v2</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">dot_product</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Dimension</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">vector_dimension</span><span class="p">(</span><span class="py">v</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">dims</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><p><strong>Indexing:</strong> HNSW index for approximate nearest neighbor search</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="py">CREATE</span><span class="w"> </span><span class="py">INDEX</span><span class="w"> </span><span class="py">doc_embedding_idx</span><span class="w"> </span><span class="py">ON</span><span class="w"> </span><span class="p">:</span><span class="nc">Document</span><span class="p">(</span><span class="py">embedding</span><span class="p">)</span><span class="w"> </span><span class="py">USING</span><span class="w"> </span><span class="py">VECTOR</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">OPTIONS</span><span class="w"> </span><span class="p">{</span><span class="w"> </span><span class="py">metric</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">cosine</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="py">dimensions</span><span class="p">:</span><span class="w"> </span><span class="nc">512</span><span class="w"> </span><span class="p">}</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><hr>
<h4 id="vector_i32" class="position-relative d-flex align-items-center group">
<span>VECTOR_I32</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="vector_i32"
aria-haspopup="dialog"
aria-label="Share link: VECTOR_I32">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>32-bit integer vector.</p>
<p><strong>Storage:</strong> 4 bytes per dimension</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="py">RETURN</span><span class="w"> </span><span class="err">'</span><span class="p">[</span><span class="py">1</span><span class="p">,</span><span class="w"> </span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">,</span><span class="w"> </span><span class="py">4</span><span class="p">]</span><span class="err">'</span><span class="p">::</span><span class="nc">vector_i32</span><span class="w"> </span><span class="nc">AS</span><span class="w"> </span><span class="py">v</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">vector_i32</span><span class="p">([</span><span class="py">1</span><span class="p">,</span><span class="w"> </span><span class="py">2</span><span class="p">,</span><span class="w"> </span><span class="py">3</span><span class="p">,</span><span class="w"> </span><span class="py">4</span><span class="p">])</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">v</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><hr>
<h3 id="geographic-types" class="position-relative d-flex align-items-center group">
<span>Geographic Types</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="geographic-types"
aria-haspopup="dialog"
aria-label="Share link: Geographic Types">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="latlon" class="position-relative d-flex align-items-center group">
<span>LATLON</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="latlon"
aria-haspopup="dialog"
aria-label="Share link: LATLON">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Latitude/longitude coordinate pair.</p>
<p><strong>Storage:</strong> 16 bytes</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Constructor</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">latlon</span><span class="p">(</span><span class="py">40</span><span class="mf">.7128</span><span class="p">,</span><span class="w"> </span><span class="err">-</span><span class="py">74</span><span class="mf">.0060</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">nyc</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Components</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">latlon</span><span class="p">(</span><span class="py">40</span><span class="mf">.7128</span><span class="p">,</span><span class="w"> </span><span class="err">-</span><span class="py">74</span><span class="mf">.0060</span><span class="p">)</span><span class="err">.</span><span class="py">latitude</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">lat</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">40</span><span class="mf">.7128</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">latlon</span><span class="p">(</span><span class="py">40</span><span class="mf">.7128</span><span class="p">,</span><span class="w"> </span><span class="err">-</span><span class="py">74</span><span class="mf">.0060</span><span class="p">)</span><span class="err">.</span><span class="py">longitude</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">lon</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="err">-</span><span class="py">74</span><span class="mf">.0060</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Distance</span><span class="w"> </span><span class="p">(</span><span class="py">meters</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">geo_distance</span><span class="p">(</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">latlon</span><span class="p">(</span><span class="py">40</span><span class="mf">.7128</span><span class="p">,</span><span class="w"> </span><span class="err">-</span><span class="py">74</span><span class="mf">.0060</span><span class="p">),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">latlon</span><span class="p">(</span><span class="py">34</span><span class="mf">.0522</span><span class="p">,</span><span class="w"> </span><span class="err">-</span><span class="py">118</span><span class="mf">.2437</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">nyc_to_la</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><p><strong>Indexing:</strong> Spatial (R-tree) index</p>
<hr>
<h4 id="geopoint" class="position-relative d-flex align-items-center group">
<span>GEOPOINT</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="geopoint"
aria-haspopup="dialog"
aria-label="Share link: GEOPOINT">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Generic geographic point.</p>
<p><strong>Storage:</strong> 16 bytes</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="py">RETURN</span><span class="w"> </span><span class="py">geopoint</span><span class="p">(</span><span class="py">40</span><span class="mf">.7128</span><span class="p">,</span><span class="w"> </span><span class="err">-</span><span class="py">74</span><span class="mf">.0060</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">point</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><hr>
<h4 id="polygon" class="position-relative d-flex align-items-center group">
<span>POLYGON</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="polygon"
aria-haspopup="dialog"
aria-label="Share link: POLYGON">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Geographic polygon (boundary).</p>
<p><strong>Storage:</strong> Variable</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Constructor</span><span class="w"> </span><span class="py">from</span><span class="w"> </span><span class="py">points</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">polygon</span><span class="p">([</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">latlon</span><span class="p">(</span><span class="py">40</span><span class="mf">.70</span><span class="p">,</span><span class="w"> </span><span class="err">-</span><span class="py">74</span><span class="mf">.05</span><span class="p">),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">latlon</span><span class="p">(</span><span class="py">40</span><span class="mf">.70</span><span class="p">,</span><span class="w"> </span><span class="err">-</span><span class="py">73</span><span class="mf">.95</span><span class="p">),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">latlon</span><span class="p">(</span><span class="py">40</span><span class="mf">.75</span><span class="p">,</span><span class="w"> </span><span class="err">-</span><span class="py">73</span><span class="mf">.95</span><span class="p">),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">latlon</span><span class="p">(</span><span class="py">40</span><span class="mf">.75</span><span class="p">,</span><span class="w"> </span><span class="err">-</span><span class="py">74</span><span class="mf">.05</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">])</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">manhattan</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Containment</span><span class="w"> </span><span class="py">check</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">s</span><span class="p">:</span><span class="nc">Store</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">geo_within_polygon</span><span class="p">(</span><span class="py">s</span><span class="err">.</span><span class="py">location</span><span class="p">,</span><span class="w"> </span><span class="nv">$manhattan_polygon</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">s</span><span class="err">.</span><span class="py">name</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><hr>
<h3 id="network-types" class="position-relative d-flex align-items-center group">
<span>Network Types</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="network-types"
aria-haspopup="dialog"
aria-label="Share link: Network Types">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="ipaddr" class="position-relative d-flex align-items-center group">
<span>IPADDR</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="ipaddr"
aria-haspopup="dialog"
aria-label="Share link: IPADDR">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>IPv4 or IPv6 address.</p>
<p><strong>Storage:</strong> 4 bytes (IPv4) or 16 bytes (IPv6)</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Constructor</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="err">'</span><span class="py">192</span><span class="mf">.168.1.100</span><span class="err">'</span><span class="p">::</span><span class="nc">ipaddr</span><span class="w"> </span><span class="nc">AS</span><span class="w"> </span><span class="py">ip4</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="err">'</span><span class="py">2001</span><span class="p">:</span><span class="nc">db8</span><span class="p">::</span><span class="nc">1</span><span class="err">'</span><span class="p">::</span><span class="nc">ipaddr</span><span class="w"> </span><span class="nc">AS</span><span class="w"> </span><span class="nc">ip6</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Version</span><span class="w"> </span><span class="py">check</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">ip_version</span><span class="p">(</span><span class="err">'</span><span class="py">192</span><span class="mf">.168.1.100</span><span class="err">'</span><span class="p">::</span><span class="nc">ipaddr</span><span class="p">)</span><span class="w"> </span><span class="nc">AS</span><span class="w"> </span><span class="py">version</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">4</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Subnet</span><span class="w"> </span><span class="py">containment</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">s</span><span class="p">:</span><span class="nc">Server</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">subnet_contains</span><span class="p">(</span><span class="err">'</span><span class="py">192</span><span class="mf">.168.0.0</span><span class="err">/</span><span class="py">16</span><span class="err">'</span><span class="p">::</span><span class="nc">subnet</span><span class="p">,</span><span class="w"> </span><span class="nc">s</span><span class="err">.</span><span class="py">ip</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">s</span><span class="err">.</span><span class="py">hostname</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><hr>
<h4 id="subnet" class="position-relative d-flex align-items-center group">
<span>SUBNET</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="subnet"
aria-haspopup="dialog"
aria-label="Share link: SUBNET">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>IP network in CIDR notation.</p>
<p><strong>Storage:</strong> 5 bytes (IPv4) or 17 bytes (IPv6)</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Constructor</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="err">'</span><span class="py">192</span><span class="mf">.168.1.0</span><span class="err">/</span><span class="py">24</span><span class="err">'</span><span class="p">::</span><span class="nc">subnet</span><span class="w"> </span><span class="nc">AS</span><span class="w"> </span><span class="py">network</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="err">'</span><span class="py">10</span><span class="mf">.0.0.0</span><span class="err">/</span><span class="py">8</span><span class="err">'</span><span class="p">::</span><span class="nc">subnet</span><span class="w"> </span><span class="nc">AS</span><span class="w"> </span><span class="py">large_network</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Containment</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">subnet_contains</span><span class="p">(</span><span class="err">'</span><span class="py">10</span><span class="mf">.0.0.0</span><span class="err">/</span><span class="py">8</span><span class="err">'</span><span class="p">::</span><span class="nc">subnet</span><span class="p">,</span><span class="w"> </span><span class="err">'</span><span class="nc">10</span><span class="mf">.1.2.3</span><span class="err">'</span><span class="p">::</span><span class="nc">ipaddr</span><span class="p">)</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="nc">true</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Network</span><span class="w"> </span><span class="py">address</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">network_address</span><span class="p">(</span><span class="err">'</span><span class="py">192</span><span class="mf">.168.1.100</span><span class="err">/</span><span class="py">24</span><span class="err">'</span><span class="p">::</span><span class="nc">subnet</span><span class="p">)</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="nc">192</span><span class="mf">.168.1.0</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Broadcast</span><span class="w"> </span><span class="py">address</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">broadcast_address</span><span class="p">(</span><span class="err">'</span><span class="py">192</span><span class="mf">.168.1.0</span><span class="err">/</span><span class="py">24</span><span class="err">'</span><span class="p">::</span><span class="nc">subnet</span><span class="p">)</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="nc">192</span><span class="mf">.168.1.255</span><span class="w">
</span></span></span></code></pre></div><p><strong>Indexing:</strong> Patricia trie for efficient prefix queries</p>
<hr>
<h4 id="macaddr" class="position-relative d-flex align-items-center group">
<span>MACADDR</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="macaddr"
aria-haspopup="dialog"
aria-label="Share link: MACADDR">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>MAC (hardware) address.</p>
<p><strong>Storage:</strong> 6 bytes</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Constructor</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="err">'</span><span class="py">00</span><span class="p">:</span><span class="nc">1A</span><span class="p">:</span><span class="nc">2B</span><span class="p">:</span><span class="nc">3C</span><span class="p">:</span><span class="nc">4D</span><span class="p">:</span><span class="nc">5E</span><span class="err">'</span><span class="p">::</span><span class="nc">macaddr</span><span class="w"> </span><span class="nc">AS</span><span class="w"> </span><span class="py">mac</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="err">'</span><span class="py">001A</span><span class="mf">.2</span><span class="py">B3C</span><span class="mf">.4</span><span class="py">D5E</span><span class="err">'</span><span class="p">::</span><span class="nc">macaddr</span><span class="w"> </span><span class="nc">AS</span><span class="w"> </span><span class="py">mac_cisco</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Manufacturer</span><span class="w"> </span><span class="py">prefix</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">mac_manufacturer_prefix</span><span class="p">(</span><span class="err">'</span><span class="py">00</span><span class="p">:</span><span class="nc">1A</span><span class="p">:</span><span class="nc">2B</span><span class="p">:</span><span class="nc">3C</span><span class="p">:</span><span class="nc">4D</span><span class="p">:</span><span class="nc">5E</span><span class="err">'</span><span class="p">::</span><span class="nc">macaddr</span><span class="p">)</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><hr>
<h3 id="structured-types" class="position-relative d-flex align-items-center group">
<span>Structured Types</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="structured-types"
aria-haspopup="dialog"
aria-label="Share link: Structured Types">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="json" class="position-relative d-flex align-items-center group">
<span>JSON</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="json"
aria-haspopup="dialog"
aria-label="Share link: JSON">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>JSON text (stored as string, parsed on access).</p>
<p><strong>Storage:</strong> Variable (UTF-8 string)</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Constructor</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="err">'</span><span class="p">{</span><span class="s">"name"</span><span class="p">:</span><span class="w"> </span><span class="s">"Alice"</span><span class="p">,</span><span class="w"> </span><span class="s">"age"</span><span class="p">:</span><span class="w"> </span><span class="nc">30</span><span class="p">}</span><span class="err">'</span><span class="p">::</span><span class="nc">json</span><span class="w"> </span><span class="nc">AS</span><span class="w"> </span><span class="nc">j</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Path</span><span class="w"> </span><span class="py">access</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">j</span><span class="err">->'</span><span class="py">name</span><span class="err">'</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">name</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="s">"Alice"</span><span class="w"> </span><span class="p">(</span><span class="py">as</span><span class="w"> </span><span class="py">JSON</span><span class="w"> </span><span class="py">string</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">j</span><span class="err">->>'</span><span class="py">name</span><span class="err">'</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">name</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">Alice</span><span class="w"> </span><span class="p">(</span><span class="py">as</span><span class="w"> </span><span class="py">text</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">j</span><span class="err">->'</span><span class="py">tags</span><span class="err">'-></span><span class="py">0</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">first_tag</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">First</span><span class="w"> </span><span class="py">array</span><span class="w"> </span><span class="py">element</span><span class="w">
</span></span></span></code></pre></div><hr>
<h4 id="jsonb" class="position-relative d-flex align-items-center group">
<span>JSONB</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="jsonb"
aria-haspopup="dialog"
aria-label="Share link: JSONB">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Binary JSON (parsed and validated on insert).</p>
<p><strong>Storage:</strong> Variable (binary format)</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Constructor</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="err">'</span><span class="p">{</span><span class="s">"name"</span><span class="p">:</span><span class="w"> </span><span class="s">"Alice"</span><span class="p">,</span><span class="w"> </span><span class="s">"tags"</span><span class="p">:</span><span class="w"> </span><span class="p">[</span><span class="sc">"a"</span><span class="p">,</span><span class="w"> </span><span class="sc">"b"</span><span class="p">]}</span><span class="err">'</span><span class="p">::</span><span class="nc">jsonb</span><span class="w"> </span><span class="nc">AS</span><span class="w"> </span><span class="nc">j</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="nc">Path</span><span class="w"> </span><span class="py">access</span><span class="w"> </span><span class="p">(</span><span class="py">same</span><span class="w"> </span><span class="py">as</span><span class="w"> </span><span class="py">JSON</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">j</span><span class="err">->'</span><span class="py">name</span><span class="err">'</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">name</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">j</span><span class="err">->'</span><span class="py">tags</span><span class="err">'-></span><span class="py">0</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">first_tag</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Containment</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="err">'</span><span class="p">{</span><span class="sc">"a"</span><span class="p">:</span><span class="w"> </span><span class="nc">1</span><span class="p">}</span><span class="err">'</span><span class="p">::</span><span class="nc">jsonb</span><span class="w"> </span><span class="err">@></span><span class="w"> </span><span class="err">'</span><span class="p">{</span><span class="sc">"a"</span><span class="p">:</span><span class="w"> </span><span class="nc">1</span><span class="p">,</span><span class="w"> </span><span class="sc">"b"</span><span class="p">:</span><span class="w"> </span><span class="nc">2</span><span class="p">}</span><span class="err">'</span><span class="p">::</span><span class="nc">jsonb</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="nc">Does</span><span class="w"> </span><span class="nc">left</span><span class="w"> </span><span class="py">contain</span><span class="w"> </span><span class="py">right</span><span class="err">?</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Key</span><span class="w"> </span><span class="py">existence</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="err">'</span><span class="p">{</span><span class="sc">"a"</span><span class="p">:</span><span class="w"> </span><span class="nc">1</span><span class="p">}</span><span class="err">'</span><span class="p">::</span><span class="nc">jsonb</span><span class="w"> </span><span class="err">?</span><span class="w"> </span><span class="err">'</span><span class="nc">a</span><span class="err">';</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">true</span><span class="w">
</span></span></span></code></pre></div><p><strong>Advantages over JSON:</strong></p>
<ul>
<li>Faster queries (pre-parsed)</li>
<li>Indexable with JSONB inverted index</li>
<li>Supports containment operators</li>
</ul>
<hr>
<h3 id="identity-types" class="position-relative d-flex align-items-center group">
<span>Identity Types</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="identity-types"
aria-haspopup="dialog"
aria-label="Share link: Identity Types">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="uuid" class="position-relative d-flex align-items-center group">
<span>UUID</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="uuid"
aria-haspopup="dialog"
aria-label="Share link: UUID">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Universally Unique Identifier (128-bit).</p>
<p><strong>Storage:</strong> 16 bytes</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Generate</span><span class="w"> </span><span class="py">random</span><span class="w"> </span><span class="py">UUID</span><span class="w"> </span><span class="p">(</span><span class="py">v4</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">gen_random_uuid</span><span class="p">()</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">id</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">From</span><span class="w"> </span><span class="py">string</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="err">'</span><span class="py">550e8400</span><span class="err">-</span><span class="py">e29b</span><span class="err">-</span><span class="py">41d4</span><span class="err">-</span><span class="py">a716</span><span class="err">-</span><span class="py">446655440000</span><span class="err">'</span><span class="p">::</span><span class="nc">uuid</span><span class="w"> </span><span class="nc">AS</span><span class="w"> </span><span class="py">id</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Version</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">uuid_version</span><span class="p">(</span><span class="err">'</span><span class="py">550e8400</span><span class="err">-</span><span class="py">e29b</span><span class="err">-</span><span class="py">41d4</span><span class="err">-</span><span class="py">a716</span><span class="err">-</span><span class="py">446655440000</span><span class="err">'</span><span class="p">::</span><span class="nc">uuid</span><span class="p">)</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="nc">4</span><span class="w">
</span></span></span></code></pre></div><p><strong>Indexing:</strong> Hash index recommended for equality lookups</p>
<hr>
<h4 id="hash" class="position-relative d-flex align-items-center group">
<span>HASH</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="hash"
aria-haspopup="dialog"
aria-label="Share link: HASH">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Cryptographic hash (e.g., SHA-256).</p>
<p><strong>Storage:</strong> Variable (depends on algorithm)</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">SHA</span><span class="err">-</span><span class="py">256</span><span class="w"> </span><span class="py">hash</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">sha256</span><span class="p">(</span><span class="err">'</span><span class="py">hello</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">hash</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Store</span><span class="w"> </span><span class="py">hash</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="p">(:</span><span class="nc">File</span><span class="w"> </span><span class="p">{</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">name</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">document</span><span class="err">.</span><span class="py">pdf</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">sha256</span><span class="p">:</span><span class="w"> </span><span class="nc">sha256</span><span class="p">(</span><span class="py">content</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">})</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Compare</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">f</span><span class="p">:</span><span class="nc">File</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">f</span><span class="err">.</span><span class="py">sha256</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">sha256</span><span class="p">(</span><span class="nv">$input_content</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">f</span><span class="err">.</span><span class="py">name</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><hr>
<h3 id="financial-types" class="position-relative d-flex align-items-center group">
<span>Financial Types</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="financial-types"
aria-haspopup="dialog"
aria-label="Share link: Financial Types">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="money" class="position-relative d-flex align-items-center group">
<span>MONEY</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="money"
aria-haspopup="dialog"
aria-label="Share link: MONEY">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Currency amount with precision.</p>
<p><strong>Storage:</strong> 8 bytes + currency code</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Constructor</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">money</span><span class="p">(</span><span class="py">99</span><span class="mf">.99</span><span class="p">,</span><span class="w"> </span><span class="err">'</span><span class="py">USD</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">price</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">money</span><span class="p">(</span><span class="py">1234</span><span class="mf">.56</span><span class="p">,</span><span class="w"> </span><span class="err">'</span><span class="py">EUR</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">euro_amount</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Arithmetic</span><span class="w"> </span><span class="p">(</span><span class="py">same</span><span class="w"> </span><span class="py">currency</span><span class="w"> </span><span class="kd">on</span><span class="py">ly</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">money</span><span class="p">(</span><span class="py">10</span><span class="mf">.00</span><span class="p">,</span><span class="w"> </span><span class="err">'</span><span class="py">USD</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">money</span><span class="p">(</span><span class="py">5</span><span class="mf">.50</span><span class="p">,</span><span class="w"> </span><span class="err">'</span><span class="py">USD</span><span class="err">'</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">total</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Currency</span><span class="w"> </span><span class="py">code</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">money</span><span class="p">(</span><span class="py">99</span><span class="mf">.99</span><span class="p">,</span><span class="w"> </span><span class="err">'</span><span class="py">USD</span><span class="err">'</span><span class="p">)</span><span class="err">.</span><span class="py">currency</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">code</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="err">'</span><span class="py">USD</span><span class="err">'</span><span class="w">
</span></span></span></code></pre></div><hr>
<h3 id="type-conversion-reference" class="position-relative d-flex align-items-center group">
<span>Type Conversion Reference</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="type-conversion-reference"
aria-haspopup="dialog"
aria-label="Share link: Type Conversion Reference">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="explicit-conversion-functions" class="position-relative d-flex align-items-center group">
<span>Explicit Conversion Functions</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="explicit-conversion-functions"
aria-haspopup="dialog"
aria-label="Share link: Explicit Conversion Functions">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><table>
<thead>
<tr>
<th>From</th>
<th>To</th>
<th>Function</th>
<th>Example</th>
</tr>
</thead>
<tbody>
<tr>
<td>STRING</td>
<td>INTEGER</td>
<td><code>toInteger()</code></td>
<td><code>toInteger('42')</code></td>
</tr>
<tr>
<td>STRING</td>
<td>FLOAT</td>
<td><code>toFloat()</code></td>
<td><code>toFloat('3.14')</code></td>
</tr>
<tr>
<td>STRING</td>
<td>BOOLEAN</td>
<td><code>toBoolean()</code></td>
<td><code>toBoolean('true')</code></td>
</tr>
<tr>
<td>*</td>
<td>STRING</td>
<td><code>toString()</code></td>
<td><code>toString(42)</code></td>
</tr>
<tr>
<td>FLOAT</td>
<td>INTEGER</td>
<td><code>toInteger()</code></td>
<td><code>toInteger(3.7)</code> (truncates to 3)</td>
</tr>
<tr>
<td>INTEGER</td>
<td>FLOAT</td>
<td><code>toFloat()</code></td>
<td><code>toFloat(42)</code></td>
</tr>
<tr>
<td>LIST</td>
<td>SET</td>
<td><code>set()</code></td>
<td><code>set([1,1,2])</code></td>
</tr>
</tbody>
</table>
<h4 id="implicit-type-promotion" class="position-relative d-flex align-items-center group">
<span>Implicit Type Promotion</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="implicit-type-promotion"
aria-haspopup="dialog"
aria-label="Share link: Implicit Type Promotion">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><table>
<thead>
<tr>
<th>Operation</th>
<th>Result Type</th>
</tr>
</thead>
<tbody>
<tr>
<td>INTEGER + INTEGER</td>
<td>INTEGER</td>
</tr>
<tr>
<td>INTEGER + FLOAT</td>
<td>FLOAT</td>
</tr>
<tr>
<td>FLOAT + FLOAT</td>
<td>FLOAT</td>
</tr>
<tr>
<td>INTEGER * FLOAT</td>
<td>FLOAT</td>
</tr>
<tr>
<td>INTEGER / INTEGER</td>
<td>INTEGER (truncates)</td>
</tr>
<tr>
<td>INTEGER / FLOAT</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<h4 id="type-checking-functions" class="position-relative d-flex align-items-center group">
<span>Type Checking Functions</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="type-checking-functions"
aria-haspopup="dialog"
aria-label="Share link: Type Checking Functions">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="py">RETURN</span><span class="w"> </span><span class="kd">type</span><span class="p">(</span><span class="nc">value</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="kd">type</span><span class="nc">_name</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">value</span><span class="w"> </span><span class="py">IS</span><span class="w"> </span><span class="py">INTEGER</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">is_int</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">value</span><span class="w"> </span><span class="py">IS</span><span class="w"> </span><span class="py">STRING</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">is_string</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">value</span><span class="w"> </span><span class="py">IS</span><span class="w"> </span><span class="py">NULL</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">is_null</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><hr>
<h3 id="type-to-index-mapping" class="position-relative d-flex align-items-center group">
<span>Type-to-Index Mapping</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="type-to-index-mapping"
aria-haspopup="dialog"
aria-label="Share link: Type-to-Index Mapping">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3><table>
<thead>
<tr>
<th>Type</th>
<th>Recommended Index</th>
<th>Operations Supported</th>
</tr>
</thead>
<tbody>
<tr>
<td>INTEGER, STRING</td>
<td>B-tree</td>
<td>=, <, >, <=, >=, BETWEEN</td>
</tr>
<tr>
<td>INTEGER, STRING</td>
<td>Hash</td>
<td>= (equality only)</td>
</tr>
<tr>
<td>STRING (text)</td>
<td>Full-text</td>
<td>Text search, BM25</td>
</tr>
<tr>
<td>JSONB</td>
<td>JSONB inverted</td>
<td>Path queries</td>
</tr>
<tr>
<td>VECTOR_F32/I32</td>
<td>HNSW</td>
<td>Similarity search</td>
</tr>
<tr>
<td>LATLON, GEOPOINT</td>
<td>Spatial</td>
<td>Distance, containment</td>
</tr>
<tr>
<td>IPADDR, SUBNET</td>
<td>Patricia trie</td>
<td>Prefix, containment</td>
</tr>
<tr>
<td>INTERVAL</td>
<td>Interval tree</td>
<td>Overlap queries</td>
</tr>
</tbody>
</table>
<hr>
<h3 id="related-documentation" class="position-relative d-flex align-items-center group">
<span>Related Documentation</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="related-documentation"
aria-haspopup="dialog"
aria-label="Share link: Related Documentation">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3><ul>
<li><a
href="/docs/model/data-model-and-types/"
>Data Model and Types</a>
- Schema design guide</li>
<li><a
href="/docs/reference/type-conversion/"
>Type Conversion</a>
- Detailed conversion rules</li>
<li><a
href="/docs/reference/indexes/"
>Index Types Reference</a>
- Indexing by type</li>
<li><a
href="/docs/reference/operators/"
>Operators Reference</a>
- Type-compatible operators</li>
</ul>
<hr>
<p><strong>Last Updated:</strong> January 28, 2026
<strong>Geode Version:</strong> <strong>v0.2.18</strong>+
<strong>Type Count:</strong> 50+ specialized types</p>
Data Types Reference
Complete reference for all 50+ data types in Geode including core types, temporal types, collection types, vector types, geographic types, and specialized types with constructors and conversion rules