website-sqlnotebook.com/array-func.html at main · brianluft/website-sqlnotebook.com · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">


<title>ARRAY Function - SQL Notebook</title>
<link rel="stylesheet" href="sqlnotebook.css">
</head>
<body>
<header>
<table class="nav">
<tr>
<td>
<a href="index.html"><img src="art/SqlNotebookIcon.png" alt="SQL Notebook (logo)" style="width: 58px; height: 58px; float: left; margin-right: 20px;"></a>
</td>
<td>
<a href="index.html" id="title">SQL Notebook</a><br>
<nav>
<ul class="nav">
<li><a href="https://github.com/brianluft/sqlnotebook/releases">Download</a></li>
<li><a href="doc.html"><span id="header-doc-long">Documentation</span><span id="header-doc-short">Docs</span></a></li>
<li><a href="https://github.com/brianluft/sqlnotebook">GitHub</a></li>
</ul>
</nav>
</td>
</tr>
</table>
<hr style="margin-top: 15px; margin-bottom: 15px;">
</header>
<article><div id="article">
<h1><code>ARRAY</code> Function</h1>
  <p>Creates an array from the specified arguments. Arrays are represented using the SQLite "BLOB" data type. They can
  be stored in tables and variables and passed as arguments to functions, just like any other value. Large arrays
  should be avoided for performance reasons. For large amounts of data, consider using a dedicated table.</p>
  <h2>Syntax</h2><code>ARRAY([<i>value</i>], ...)</code><br>
  <h2>Parameters</h2>
  <ul class="args">
    <li><i>value</i>, ...: scalar<br>
    The values to include in the array.</li>
  </ul>
  <h2>Return Value</h2>A <code>BLOB</code> value containing the encoded array.<br>
  <h2>Example</h2>
  <pre>DECLARE @data = ARRAY(111, 222, 333);<br>PRINT ARRAY_GET(@data, 0);  <i>-- "111"</i><br>PRINT ARRAY_GET(@data, 2);  <i>-- "333"<br></i></pre>
  <h2>See Also</h2>
  <ul>
    <li>
      <a moz-do-not-send="true" href="array-get-func.html"><tt>ARRAY_GET</tt> Function</a><br>
    </li>
  </ul>
</div></article>
<footer><div id="footer">
<hr>
© 2016-2025 <a href="https://github.com/electroly">Brian Luft</a>
</div></footer>
</body>
</html>