Type Conversion Functions | Geode Database

<h3 id="overview" class="position-relative d-flex align-items-center group"> Overview <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="overview" aria-haspopup="dialog" aria-label="Share link: Overview"> Share link </button> </h3><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"> </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"> </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"> Twitter </a> <a id="share-linkedin" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> LinkedIn </a> <a id="share-facebook" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> 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>Geode implements comprehensive type conversion functions as specified in the ISO/IEC 39075:2024 GQL standard. These functions enable safe type casting, type introspection, and data transformation for robust query operations. <h4 id="supported-functions" class="position-relative d-flex align-items-center group"> Supported Functions <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="supported-functions" aria-haspopup="dialog" aria-label="Share link: Supported Functions"> Share link </button> </h4><table> <thead> <tr> <th>Function</th> <th>Purpose</th> <th>Input Types</th> <th>Output Type</th> </tr> </thead> <tbody> <tr> <td><code>type()</code></td> <td>Return type name</td> <td>Any</td> <td>STRING</td> </tr> <tr> <td><code>toString()</code></td> <td>Convert to string</td> <td>Any</td> <td>STRING</td> </tr> <tr> <td><code>toInteger()</code></td> <td>Convert to integer</td> <td>String, Numeric</td> <td>INTEGER</td> </tr> <tr> <td><code>toReal()</code></td> <td>Convert to real number</td> <td>String, Numeric</td> <td>DECIMAL</td> </tr> </tbody> </table> <h3 id="type-function" class="position-relative d-flex align-items-center group"> type() Function <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-function" aria-haspopup="dialog" aria-label="Share link: type() Function"> Share link </button> </h3> <h4 id="description" class="position-relative d-flex align-items-center group"> Description <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="description" aria-haspopup="dialog" aria-label="Share link: Description"> Share link </button> </h4>Returns the data type name of any value as a string. <h4 id="syntax" class="position-relative d-flex align-items-center group"> Syntax <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="syntax" aria-haspopup="dialog" aria-label="Share link: Syntax"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">type(value) → STRING </code></pre></div> <h4 id="parameters" class="position-relative d-flex align-items-center group"> Parameters <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="parameters" aria-haspopup="dialog" aria-label="Share link: Parameters"> Share link </button> </h4><ul> <li>value: Any GQL value (required)</li> </ul> <h4 id="return-value" class="position-relative d-flex align-items-center group"> Return Value <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="return-value" aria-haspopup="dialog" aria-label="Share link: Return Value"> Share link </button> </h4>String representation of the value’s type according to GQL type system. <h4 id="type-names" class="position-relative d-flex align-items-center group"> Type Names <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-names" aria-haspopup="dialog" aria-label="Share link: Type Names"> Share link </button> </h4><table> <thead> <tr> <th>GQL Type</th> <th>Returned String</th> </tr> </thead> <tbody> <tr> <td>Integer</td> <td><code>"INTEGER"</code></td> </tr> <tr> <td>Decimal/Float</td> <td><code>"DECIMAL"</code></td> </tr> <tr> <td>String</td> <td><code>"STRING"</code></td> </tr> <tr> <td>Boolean</td> <td><code>"BOOLEAN"</code></td> </tr> <tr> <td>Null</td> <td><code>"NULL"</code></td> </tr> <tr> <td>Date</td> <td><code>"DATE"</code></td> </tr> <tr> <td>Time</td> <td><code>"TIME"</code></td> </tr> <tr> <td>DateTime</td> <td><code>"DATETIME"</code></td> </tr> <tr> <td>Duration</td> <td><code>"DURATION"</code></td> </tr> <tr> <td>List</td> <td><code>"LIST"</code></td> </tr> <tr> <td>Map</td> <td><code>"MAP"</code></td> </tr> <tr> <td>Node</td> <td><code>"NODE"</code></td> </tr> <tr> <td>Relationship</td> <td><code>"RELATIONSHIP"</code></td> </tr> <tr> <td>Path</td> <td><code>"PATH"</code></td> </tr> </tbody> </table> <h4 id="examples" class="position-relative d-flex align-items-center group"> Examples <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="examples" aria-haspopup="dialog" aria-label="Share link: Examples"> Share link </button> </h4>Basic Types: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">RETURN type(123) -- "INTEGER" RETURN type('hello') -- "STRING" RETURN type(123.45) -- "DECIMAL" RETURN type(true) -- "BOOLEAN" RETURN type(null) -- "NULL" </code></pre></div>Temporal Types: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">RETURN type(date('2026-01-24')) -- "DATE" RETURN type(time('10:30:15')) -- "TIME" RETURN type(datetime('2026-01-24T10:30:15')) -- "DATETIME" RETURN type(duration('PT1H30M')) -- "DURATION" </code></pre></div>Collection Types: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">RETURN type([1, 2, 3]) -- "LIST" RETURN type({name: 'Alice', age: 30}) -- "MAP" </code></pre></div>Graph Types: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (n:Person) RETURN type(n) -- "NODE" MATCH ()-[r:KNOWS]->() RETURN type(r) -- "RELATIONSHIP" MATCH p = (:Person)-[:KNOWS*]->(:Person) RETURN type(p) -- "PATH" </code></pre></div> <h4 id="use-cases" class="position-relative d-flex align-items-center group"> Use Cases <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="use-cases" aria-haspopup="dialog" aria-label="Share link: Use Cases"> Share link </button> </h4>Runtime Type Checking: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Conditional logic based on type MATCH (n) RETURN n, CASE type(n.value) WHEN 'INTEGER' THEN 'Numeric value' WHEN 'STRING' THEN 'Text value' ELSE 'Other type' END AS value_category </code></pre></div>Type Validation: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find nodes with unexpected property types MATCH (p:Product) WHERE type(p.price) <> 'DECIMAL' RETURN p.id, type(p.price) AS wrong_type, p.price </code></pre></div>Schema Discovery: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Discover property types in graph MATCH (n:User) UNWIND keys(n) AS prop_name WITH prop_name, n[prop_name] AS prop_value RETURN DISTINCT prop_name, type(prop_value) AS prop_type ORDER BY prop_name </code></pre></div> <h3 id="tostring-function" class="position-relative d-flex align-items-center group"> toString() Function <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="tostring-function" aria-haspopup="dialog" aria-label="Share link: toString() Function"> Share link </button> </h3> <h4 id="description-1" class="position-relative d-flex align-items-center group"> Description <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="description-1" aria-haspopup="dialog" aria-label="Share link: Description"> Share link </button> </h4>Converts any value to its string representation. <h4 id="syntax-1" class="position-relative d-flex align-items-center group"> Syntax <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="syntax-1" aria-haspopup="dialog" aria-label="Share link: Syntax"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">toString(value) → STRING </code></pre></div> <h4 id="parameters-1" class="position-relative d-flex align-items-center group"> Parameters <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="parameters-1" aria-haspopup="dialog" aria-label="Share link: Parameters"> Share link </button> </h4><ul> <li>value: Any GQL value (required)</li> </ul> <h4 id="return-value-1" class="position-relative d-flex align-items-center group"> Return Value <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="return-value-1" aria-haspopup="dialog" aria-label="Share link: Return Value"> Share link </button> </h4>String representation of the input value, or <code>null</code> if conversion fails. <h4 id="conversion-rules" class="position-relative d-flex align-items-center group"> Conversion Rules <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="conversion-rules" aria-haspopup="dialog" aria-label="Share link: Conversion Rules"> Share link </button> </h4><table> <thead> <tr> <th>Input Type</th> <th>Output Example</th> </tr> </thead> <tbody> <tr> <td>Integer</td> <td><code>toString(123)</code> → <code>"123"</code></td> </tr> <tr> <td>Decimal</td> <td><code>toString(123.45)</code> → <code>"123.450000"</code></td> </tr> <tr> <td>Boolean</td> <td><code>toString(true)</code> → <code>"true"</code></td> </tr> <tr> <td>String</td> <td><code>toString("hello")</code> → <code>"hello"</code></td> </tr> <tr> <td>Null</td> <td><code>toString(null)</code> → <code>"null"</code></td> </tr> <tr> <td>Date</td> <td><code>toString(date('2026-01-24'))</code> → <code>"2026-01-24"</code></td> </tr> <tr> <td>DateTime</td> <td><code>toString(datetime(...))</code> → <code>"2026-01-24T10:30:15Z"</code></td> </tr> <tr> <td>List</td> <td><code>toString([1,2,3])</code> → <code>"[1, 2, 3]"</code></td> </tr> <tr> <td>Map</td> <td><code>toString({a:1})</code> → <code>"{a: 1}"</code></td> </tr> </tbody> </table> <h4 id="examples-1" class="position-relative d-flex align-items-center group"> Examples <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="examples-1" aria-haspopup="dialog" aria-label="Share link: Examples"> Share link </button> </h4>Basic Conversion: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">RETURN toString(123) -- "123" RETURN toString(true) -- "true" RETURN toString(null) -- "null" RETURN toString(123.45) -- "123.450000" </code></pre></div>Temporal Values: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">RETURN toString(date('2026-01-24')) -- "2026-01-24" RETURN toString(datetime('2026-01-24T10:30:15')) -- "2026-01-24T10:30:15Z" RETURN toString(duration('PT1H30M')) -- "PT1H30M" </code></pre></div>Collection Values: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">RETURN toString([1, 2, 3, 4, 5]) -- "[1, 2, 3, 4, 5]" RETURN toString({name: 'Alice', age: 30}) -- "{name: 'Alice', age: 30}" </code></pre></div> <h4 id="use-cases-1" class="position-relative d-flex align-items-center group"> Use Cases <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="use-cases-1" aria-haspopup="dialog" aria-label="Share link: Use Cases"> Share link </button> </h4>String Concatenation: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Build formatted strings MATCH (p:Person) RETURN 'Person #' + toString(p.id) + ': ' + p.name AS label </code></pre></div>Export Formatting: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Format data for export MATCH (o:Order) RETURN toString(o.created_date) + ',' + toString(o.id) + ',' + toString(o.total) AS csv_row </code></pre></div>Logging & Debugging: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Convert values for logging MATCH (n) WHERE n.updated_at > datetime().subtract(PT1H) RETURN 'Updated: ' + toString(n.id) + ' at ' + toString(n.updated_at) AS log_entry </code></pre></div> <h3 id="tointeger-function" class="position-relative d-flex align-items-center group"> toInteger() Function <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="tointeger-function" aria-haspopup="dialog" aria-label="Share link: toInteger() Function"> Share link </button> </h3> <h4 id="description-2" class="position-relative d-flex align-items-center group"> Description <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="description-2" aria-haspopup="dialog" aria-label="Share link: Description"> Share link </button> </h4>Converts strings and numeric values to integers with overflow protection. <h4 id="syntax-2" class="position-relative d-flex align-items-center group"> Syntax <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="syntax-2" aria-haspopup="dialog" aria-label="Share link: Syntax"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">toInteger(value) → INTEGER | NULL </code></pre></div> <h4 id="parameters-2" class="position-relative d-flex align-items-center group"> Parameters <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="parameters-2" aria-haspopup="dialog" aria-label="Share link: Parameters"> Share link </button> </h4><ul> <li>value: String or numeric value (required)</li> </ul> <h4 id="return-value-2" class="position-relative d-flex align-items-center group"> Return Value <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="return-value-2" aria-haspopup="dialog" aria-label="Share link: Return Value"> Share link </button> </h4>Integer value, or <code>null</code> if conversion fails or value is invalid. <h4 id="conversion-rules-1" class="position-relative d-flex align-items-center group"> Conversion Rules <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="conversion-rules-1" aria-haspopup="dialog" aria-label="Share link: Conversion Rules"> Share link </button> </h4><table> <thead> <tr> <th>Input</th> <th>Output</th> <th>Notes</th> </tr> </thead> <tbody> <tr> <td>String (valid)</td> <td>Integer</td> <td><code>toInteger('456')</code> → <code>456</code></td> </tr> <tr> <td>String (invalid)</td> <td><code>null</code></td> <td><code>toInteger('abc')</code> → <code>null</code></td> </tr> <tr> <td>Decimal</td> <td>Integer</td> <td><code>toInteger(123.7)</code> → <code>123</code> (truncated)</td> </tr> <tr> <td>Integer</td> <td>Integer</td> <td><code>toInteger(123)</code> → <code>123</code> (unchanged)</td> </tr> <tr> <td>Boolean</td> <td><code>null</code></td> <td><code>toInteger(true)</code> → <code>null</code></td> </tr> <tr> <td>Null</td> <td><code>null</code></td> <td><code>toInteger(null)</code> → <code>null</code></td> </tr> <tr> <td>Overflow</td> <td><code>null</code></td> <td>Value too large → <code>null</code></td> </tr> </tbody> </table> <h4 id="examples-2" class="position-relative d-flex align-items-center group"> Examples <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="examples-2" aria-haspopup="dialog" aria-label="Share link: Examples"> Share link </button> </h4>String Conversion: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">RETURN toInteger('456') -- 456 RETURN toInteger('123.45') -- 123 (decimal part ignored) RETURN toInteger('abc') -- null (invalid format) RETURN toInteger('') -- null (empty string) </code></pre></div>Numeric Conversion: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">RETURN toInteger(123) -- 123 RETURN toInteger(123.7) -- 123 (truncated, not rounded) RETURN toInteger(123.999) -- 123 (truncated) RETURN toInteger(-456.789) -- -456 </code></pre></div>Edge Cases: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">RETURN toInteger(null) -- null RETURN toInteger(' 123 ') -- 123 (whitespace trimmed) RETURN toInteger('+456') -- 456 (plus sign allowed) RETURN toInteger('-789') -- -789 (negative numbers) </code></pre></div> <h4 id="overflow-protection" class="position-relative d-flex align-items-center group"> Overflow Protection <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="overflow-protection" aria-haspopup="dialog" aria-label="Share link: Overflow Protection"> Share link </button> </h4>Safe Range (64-bit signed integer): <ul> <li>Minimum: <code>-9,223,372,036,854,775,808</code></li> <li>Maximum: <code>9,223,372,036,854,775,807</code></li> </ul> Overflow Behavior: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">RETURN toInteger('9999999999999999999999') -- null (overflow) RETURN toInteger('-9999999999999999999999') -- null (underflow) </code></pre></div> <h4 id="use-cases-2" class="position-relative d-flex align-items-center group"> Use Cases <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="use-cases-2" aria-haspopup="dialog" aria-label="Share link: Use Cases"> Share link </button> </h4>User Input Processing: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Convert user input to integer WITH '42' AS user_input MATCH (p:Product) WHERE p.id = toInteger(user_input) RETURN p.name </code></pre></div>Data Cleaning: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Clean imported data MATCH (n:ImportedData) WHERE n.count_str IS NOT NULL SET n.count = toInteger(n.count_str) </code></pre></div>Pagination: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Convert pagination parameters WITH '10' AS page_size_param, '2' AS page_num_param MATCH (n:Article) RETURN n SKIP toInteger(page_size_param) * (toInteger(page_num_param) - 1) LIMIT toInteger(page_size_param) </code></pre></div> <h3 id="toreal-function" class="position-relative d-flex align-items-center group"> toReal() Function <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="toreal-function" aria-haspopup="dialog" aria-label="Share link: toReal() Function"> Share link </button> </h3> <h4 id="description-3" class="position-relative d-flex align-items-center group"> Description <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="description-3" aria-haspopup="dialog" aria-label="Share link: Description"> Share link </button> </h4>Converts values to floating-point numbers (returned as DECIMAL type). <h4 id="syntax-3" class="position-relative d-flex align-items-center group"> Syntax <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="syntax-3" aria-haspopup="dialog" aria-label="Share link: Syntax"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">toReal(value) → DECIMAL | NULL </code></pre></div> <h4 id="parameters-3" class="position-relative d-flex align-items-center group"> Parameters <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="parameters-3" aria-haspopup="dialog" aria-label="Share link: Parameters"> Share link </button> </h4><ul> <li>value: String or numeric value (required)</li> </ul> <h4 id="return-value-3" class="position-relative d-flex align-items-center group"> Return Value <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="return-value-3" aria-haspopup="dialog" aria-label="Share link: Return Value"> Share link </button> </h4>Decimal value, or <code>null</code> if conversion fails. <h4 id="conversion-rules-2" class="position-relative d-flex align-items-center group"> Conversion Rules <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="conversion-rules-2" aria-haspopup="dialog" aria-label="Share link: Conversion Rules"> Share link </button> </h4><table> <thead> <tr> <th>Input</th> <th>Output</th> <th>Notes</th> </tr> </thead> <tbody> <tr> <td>String (valid)</td> <td>Decimal</td> <td><code>toReal('123.45')</code> → <code>123.450000</code></td> </tr> <tr> <td>String (invalid)</td> <td><code>null</code></td> <td><code>toReal('abc')</code> → <code>null</code></td> </tr> <tr> <td>Integer</td> <td>Decimal</td> <td><code>toReal(123)</code> → <code>123.000000</code></td> </tr> <tr> <td>Decimal</td> <td>Decimal</td> <td><code>toReal(123.45)</code> → <code>123.450000</code></td> </tr> <tr> <td>Scientific</td> <td>Decimal</td> <td><code>toReal('1.5e2')</code> → <code>150.000000</code></td> </tr> <tr> <td>Null</td> <td><code>null</code></td> <td><code>toReal(null)</code> → <code>null</code></td> </tr> </tbody> </table> <h4 id="examples-3" class="position-relative d-flex align-items-center group"> Examples <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="examples-3" aria-haspopup="dialog" aria-label="Share link: Examples"> Share link </button> </h4>String Conversion: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">RETURN toReal('123.45') -- 123.450000 RETURN toReal('456') -- 456.000000 RETURN toReal('1.5e2') -- 150.000000 (scientific notation) RETURN toReal('abc') -- null (invalid format) </code></pre></div>Numeric Conversion: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">RETURN toReal(123) -- 123.000000 RETURN toReal(123.45) -- 123.450000 RETURN toReal(-456.789) -- -456.789000 </code></pre></div>Scientific Notation: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">RETURN toReal('1.23e-4') -- 0.000123 RETURN toReal('5.67E+3') -- 5670.000000 RETURN toReal('2.5e10') -- 25000000000.000000 </code></pre></div> <h4 id="precision" class="position-relative d-flex align-items-center group"> Precision <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="precision" aria-haspopup="dialog" aria-label="Share link: Precision"> Share link </button> </h4>Default Precision: 6 decimal places Range: <ul> <li>Minimum: Approximately <code>-1.7976931348623157e+308</code></li> <li>Maximum: Approximately <code>1.7976931348623157e+308</code></li> </ul> <h4 id="use-cases-3" class="position-relative d-flex align-items-center group"> Use Cases <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="use-cases-3" aria-haspopup="dialog" aria-label="Share link: Use Cases"> Share link </button> </h4>Financial Calculations: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Convert price strings to decimals MATCH (p:Product) WHERE p.price_str IS NOT NULL SET p.price = toReal(p.price_str) </code></pre></div>Statistical Analysis: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Calculate averages from string data MATCH (m:Metric) WITH toReal(m.value_str) AS value WHERE value IS NOT NULL RETURN avg(value) AS average_value </code></pre></div>Percentage Calculations: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Convert percentage strings to decimals MATCH (s:Sale) SET s.discount_rate = toReal(s.discount_percent_str) / 100.0 </code></pre></div> <h3 id="type-conversion-compatibility" class="position-relative d-flex align-items-center group"> Type Conversion Compatibility <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-compatibility" aria-haspopup="dialog" aria-label="Share link: Type Conversion Compatibility"> Share link </button> </h3> <h4 id="conversion-matrix" class="position-relative d-flex align-items-center group"> Conversion Matrix <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="conversion-matrix" aria-haspopup="dialog" aria-label="Share link: Conversion Matrix"> Share link </button> </h4><table> <thead> <tr> <th>From ↓ / To →</th> <th>STRING</th> <th>INTEGER</th> <th>DECIMAL</th> <th>BOOLEAN</th> <th>DATE</th> </tr> </thead> <tbody> <tr> <td>STRING</td> <td>✓</td> <td>✓</td> <td>✓</td> <td>✗</td> <td>✗</td> </tr> <tr> <td>INTEGER</td> <td>✓</td> <td>✓</td> <td>✓</td> <td>✗</td> <td>✗</td> </tr> <tr> <td>DECIMAL</td> <td>✓</td> <td>✓ (truncate)</td> <td>✓</td> <td>✗</td> <td>✗</td> </tr> <tr> <td>BOOLEAN</td> <td>✓</td> <td>✗</td> <td>✗</td> <td>✓</td> <td>✗</td> </tr> <tr> <td>DATE</td> <td>✓</td> <td>✗</td> <td>✗</td> <td>✗</td> <td>✓</td> </tr> <tr> <td>NULL</td> <td>✓ (<code>"null"</code>)</td> <td><code>null</code></td> <td><code>null</code></td> <td><code>null</code></td> <td><code>null</code></td> </tr> </tbody> </table> Legend: <ul> <li>✓ : Supported conversion</li> <li>✗ : Not supported (returns <code>null</code>)</li> </ul> <h4 id="safe-conversion-patterns" class="position-relative d-flex align-items-center group"> Safe Conversion Patterns <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="safe-conversion-patterns" aria-haspopup="dialog" aria-label="Share link: Safe Conversion Patterns"> Share link </button> </h4>Check Before Convert: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Validate before conversion MATCH (n) WHERE n.value IS NOT NULL AND type(n.value) IN ['STRING', 'INTEGER', 'DECIMAL'] WITH toInteger(n.value) AS int_value WHERE int_value IS NOT NULL RETURN int_value </code></pre></div>Provide Defaults: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Use COALESCE for default values MATCH (n) RETURN coalesce(toInteger(n.value), 0) AS value_or_default </code></pre></div>Chain Conversions: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Convert through intermediate types MATCH (n) WITH toString(n.id) AS id_str RETURN 'ID: ' + id_str AS formatted_id </code></pre></div> <h3 id="common-patterns" class="position-relative d-flex align-items-center group"> Common Patterns <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="common-patterns" aria-haspopup="dialog" aria-label="Share link: Common Patterns"> Share link </button> </h3> <h4 id="data-import" class="position-relative d-flex align-items-center group"> Data Import <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-import" aria-haspopup="dialog" aria-label="Share link: Data Import"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Import CSV data with type conversion LOAD CSV FROM 'data.csv' AS row CREATE (p:Product { id: toInteger(row.id), name: row.name, price: toReal(row.price), in_stock: row.in_stock = 'true', created_date: date(row.created_date) }) </code></pre></div> <h4 id="data-validation" class="position-relative d-flex align-items-center group"> Data Validation <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-validation" aria-haspopup="dialog" aria-label="Share link: Data Validation"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find invalid data MATCH (p:Product) WHERE toReal(p.price_str) IS NULL AND p.price_str IS NOT NULL RETURN p.id, p.price_str AS invalid_price </code></pre></div> <h4 id="type-safe-aggregations" class="position-relative d-flex align-items-center group"> Type-Safe Aggregations <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-safe-aggregations" aria-haspopup="dialog" aria-label="Share link: Type-Safe Aggregations"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Aggregate with type conversion MATCH (m:Metric) WITH toReal(m.value) AS numeric_value WHERE numeric_value IS NOT NULL RETURN avg(numeric_value) AS average, max(numeric_value) AS maximum, min(numeric_value) AS minimum </code></pre></div> <h4 id="string-formatting" class="position-relative d-flex align-items-center group"> String Formatting <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-formatting" aria-haspopup="dialog" aria-label="Share link: String Formatting"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Build formatted reports MATCH (s:Sale) RETURN 'Sale #' + toString(s.id) + ' on ' + toString(date(s.created_date)) + ' for $' + toString(s.amount) AS summary </code></pre></div> <h3 id="known-limitations" class="position-relative d-flex align-items-center group"> Known Limitations <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="known-limitations" aria-haspopup="dialog" aria-label="Share link: Known Limitations"> Share link </button> </h3> <h4 id="property-access" class="position-relative d-flex align-items-center group"> Property Access <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="property-access" aria-haspopup="dialog" aria-label="Share link: Property Access"> Share link </button> </h4>Current Issue: Property access within function calls may return null <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- This may not work as expected MATCH (n:Person) RETURN toString(n.name) -- May return null -- Workaround: Use WITH clause MATCH (n:Person) WITH n.name AS name RETURN toString(name) -- Works correctly </code></pre></div>Status: Known issue, targeted for future improvement <h4 id="type-function-context" class="position-relative d-flex align-items-center group"> Type Function Context <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-function-context" aria-haspopup="dialog" aria-label="Share link: Type Function Context"> Share link </button> </h4>The <code>type()</code> function has dual semantics in GQL: <ol> <li> Graph Element Type (relationship labels): <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH ()-[r]->() RETURN type(r) -- Returns relationship type name </code></pre></div></li> <li> Value Data Type (our implementation): <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">RETURN type(123) -- Returns "INTEGER" </code></pre></div></li> </ol> Current: Works with literals, limited property support <h3 id="testing" class="position-relative d-flex align-items-center group"> Testing <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="testing" aria-haspopup="dialog" aria-label="Share link: Testing"> Share link </button> </h3> <h4 id="unit-tests" class="position-relative d-flex align-items-center group"> Unit Tests <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="unit-tests" aria-haspopup="dialog" aria-label="Share link: Unit Tests"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Run type conversion tests zig test tests/test_type_conversion.zig # Regression tests ./tests/type_conversion_functions_regression_test.sh </code></pre></div> <h4 id="test-coverage" class="position-relative d-flex align-items-center group"> Test Coverage <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="test-coverage" aria-haspopup="dialog" aria-label="Share link: Test Coverage"> Share link </button> </h4>Tested Scenarios: <ul> <li>✓ All basic types (INTEGER, STRING, DECIMAL, BOOLEAN, NULL)</li> <li>✓ Temporal types (DATE, TIME, DATETIME, DURATION)</li> <li>✓ Collection types (LIST, MAP)</li> <li>✓ Graph types (NODE, RELATIONSHIP, PATH)</li> <li>✓ Edge cases (overflow, underflow, invalid formats)</li> <li>✓ Null handling</li> <li>✓ Whitespace trimming</li> <li>✓ Scientific notation</li> </ul> <h4 id="example-tests" class="position-relative d-flex align-items-center group"> Example Tests <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="example-tests" aria-haspopup="dialog" aria-label="Share link: Example Tests"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Basic function tests RETURN toString(123) = '123' -- true RETURN toInteger('456') = 456 -- true RETURN toReal('123.45') = 123.45 -- true RETURN type(123) = 'INTEGER' -- true -- Edge case tests RETURN toInteger('abc') IS NULL -- true RETURN toReal('invalid') IS NULL -- true RETURN toInteger(' 123 ') = 123 -- true (whitespace) </code></pre></div> <h3 id="performance" class="position-relative d-flex align-items-center group"> Performance <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="performance" aria-haspopup="dialog" aria-label="Share link: Performance"> Share link </button> </h3> <h4 id="benchmark-results" class="position-relative d-flex align-items-center group"> Benchmark Results <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="benchmark-results" aria-haspopup="dialog" aria-label="Share link: Benchmark Results"> Share link </button> </h4>toString(): <ul> <li>Overhead: <1μs per conversion</li> <li>Throughput: >1M conversions/second</li> <li>Memory: Allocates new string (minimal)</li> </ul> toInteger(): <ul> <li>Efficient parsing for valid integers</li> <li>Format validation</li> <li>Returns null on invalid input</li> </ul> toReal(): <ul> <li>Handles decimal and scientific notation</li> <li>Precision: 6 decimal places (standard)</li> </ul> type(): <ul> <li>Constant time type lookup</li> <li>Cached string literals for common types</li> </ul> <h3 id="best-practices" class="position-relative d-flex align-items-center group"> Best Practices <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="best-practices" aria-haspopup="dialog" aria-label="Share link: Best Practices"> Share link </button> </h3> <h4 id="type-safety" class="position-relative d-flex align-items-center group"> Type Safety <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-safety" aria-haspopup="dialog" aria-label="Share link: Type Safety"> Share link </button> </h4><ol> <li> Always Validate: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Check conversion success WITH toInteger(user_input) AS value WHERE value IS NOT NULL RETURN value </code></pre></div></li> <li> Provide Defaults: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Use COALESCE for safety RETURN coalesce(toInteger(n.value), 0) </code></pre></div></li> <li> Type Check First: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Verify type before conversion WHERE type(n.value) IN ['STRING', 'INTEGER'] </code></pre></div></li> </ol> <h4 id="error-handling" class="position-relative d-flex align-items-center group"> Error Handling <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="error-handling" aria-haspopup="dialog" aria-label="Share link: Error Handling"> Share link </button> </h4>Production Pattern: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Comprehensive error handling MATCH (n:Data) WITH n, toInteger(n.count_str) AS count_int, toReal(n.price_str) AS price_real WHERE count_int IS NOT NULL AND price_real IS NOT NULL RETURN n.id, count_int, price_real </code></pre></div>Logging Invalid Data: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Track conversion failures MATCH (n:ImportedData) WITH n, toInteger(n.value) AS int_value WHERE n.value IS NOT NULL AND int_value IS NULL CREATE (e:ConversionError { entity_id: n.id, field: 'value', attempted_value: n.value, error_time: datetime() }) </code></pre></div> <h3 id="references" class="position-relative d-flex align-items-center group"> References <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="references" aria-haspopup="dialog" aria-label="Share link: References"> Share link </button> </h3> <h4 id="standards" class="position-relative d-flex align-items-center group"> Standards <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="standards" aria-haspopup="dialog" aria-label="Share link: Standards"> Share link </button> </h4><ul> <li>ISO/IEC 39075:2024: GQL Type System and Type Conversion <ul> <li>Section on scalar type functions</li> <li>Type compatibility matrix</li> </ul> </li> </ul> <h4 id="code-location" class="position-relative d-flex align-items-center group"> Code Location <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="code-location" aria-haspopup="dialog" aria-label="Share link: Code Location"> Share link </button> </h4><ul> <li>Implementation: <code>src/types/evaluator_functions.zig</code></li> <li>Registration: <code>src/eval.zig</code></li> <li>Tests: <code>tests/type_conversion_functions_regression_test.sh</code></li> <li>Documentation: <code>docs/TYPE_CONVERSION_FUNCTIONS.md</code></li> </ul> <h4 id="related-documentation" class="position-relative d-flex align-items-center group"> Related Documentation <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"> Share link </button> </h4><ul> <li><a href="/docs/data-types/_index/" >Data Types Reference</a> - Complete type system</li> <li><a href="/docs/reference/api-reference-complete/" >GQL Functions</a> - All built-in functions</li> <li><a href="/docs/model/data-model-and-types/" >Type System</a> - Data model overview</li> </ul> <h3 id="next-steps" class="position-relative d-flex align-items-center group"> Next Steps <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="next-steps" aria-haspopup="dialog" aria-label="Share link: Next Steps"> Share link </button> </h3>For New Users: <ul> <li><a href="/docs/data-types/_index/" >Data Types Overview</a> - Type system fundamentals</li> <li><a href="/docs/gql/guide/" >GQL Guide</a> - Query language basics</li> <li><a href="/docs/reference/cli-and-api/" >Quick Reference</a> - Command reference</li> </ul> For Developers: <ul> <li><a href="/docs/reference/api-reference-complete/" >API Reference</a> - Complete function reference</li> <li><a href="/docs/guides/testing-strategies/" >Testing Strategies</a> - Type validation testing</li> <li><a href="/docs/client-libraries/go-client/" >Client Libraries</a> - Type handling in clients</li> </ul> <hr> Document Version: 1.0 Last Updated: January 24, 2026 Status: Production Ready ISO Compliance: ISO/IEC 39075:2024 GQL Type System CANARY: REQ-GQL-TYPE-CONV-001 (TESTED)