Documentation Source Text

Check-in [bfb7a9010a]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:The PRAGMA table-valued function feature is no longer experiemental. It is a long-established and stable feature that we depend upon. Update the docs to say as much. Cherry-picked onto the 3.40 branch by request of forum post a86299ccc3.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | branch-3.40
Files: files | file ages | folders
SHA3-256: bfb7a9010a6f426c0b8e791e596bcf308845a0c8fbb2ca7728f4975fac7946e7
User & Date: drh 2023-01-04 16:18:24.409
Context
2023-01-25
11:13
Change labels on the download page to say "SHA3-256" instead of just SHA3. (check-in: 54db71c83a user: drh tags: branch-3.40)
2023-01-04
16:23
Merge the latest branch-3.40 changes into trunk. (check-in: 2d2e584cf1 user: drh tags: trunk)
16:18
The PRAGMA table-valued function feature is no longer experiemental. It is a long-established and stable feature that we depend upon. Update the docs to say as much. Cherry-picked onto the 3.40 branch by request of forum post a86299ccc3. (check-in: bfb7a9010a user: drh tags: branch-3.40)
16:14
Update the Expensify logo on the homepage to the latest version of their official logo. (check-in: 1b31b16a2d user: drh tags: branch-3.40)
2022-12-25
13:08
The PRAGMA table-valued function feature is no longer experiemental. It is a long-established and stable feature that we depend upon. Update the docs to say as much. (check-in: 2a5f5900ae user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/pragma.in.
︙︙
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244

<blockquote><pre>
[ATTACH] ':memory:' AS 'information_schema';
</pre></blockquote>
Then creating
[VIEW|VIEWs] in that schema that implement the official information schema
tables using table-valued PRAGMA functions.
<li><p>
This feature is experimental and is subject to change.  Further documentation
will become available if and when the table-valued functions for PRAGMAs
feature becomes officially supported.
<li><p>
The table-valued functions for PRAGMA feature was added
in SQLite version 3.16.0 ([dateof:3.16.0]).  Prior versions of SQLite
cannot use this feature.
</ul>
<tcl>

Pragma {analysis_limit} {








<
<
<
<








227
228
229
230
231
232
233




234
235
236
237
238
239
240

<blockquote><pre>
[ATTACH] ':memory:' AS 'information_schema';
</pre></blockquote>
Then creating
[VIEW|VIEWs] in that schema that implement the official information schema
tables using table-valued PRAGMA functions.
<li><p>




The table-valued functions for PRAGMA feature was added
in SQLite version 3.16.0 ([dateof:3.16.0]).  Prior versions of SQLite
cannot use this feature.
</ul>
<tcl>

Pragma {analysis_limit} {
︙︙