1-50 of 417 found
PLAN: LATERAL Join Support (Subqueries with LATERAL)
LATERAL subquery referencing another LATERAL: FROM t, LATERAL (...) AS a, LATERAL (SELECT a.col ...) — chained LATERAL references. The second LATERAL depends on the first.
LATERAL Joins in a Stream Table
Limitations Volatile functions in LATERAL: If the LATERAL subquery calls a VOLATILE function (e.g., random(), clock_timestamp()), the result is non-deterministic.
README
… modify it under the [GNU General Public License version 3 or later]. [GNU General Public License version 3 or later]: http://www.gnu.org/copyleft/gpl.html
pg_later
pg_later Execute SQL now and get the results later. A postgres extension to execute queries asynchronously. Built on pgmq. Installation Run with docker docker run -p 5432:5432 -e…
Eigen_v3.0.3
… at your choice, > * either under the LGPL, version 3 or later, > * or under the GPL, version 2 or later. > > Note that this is an OR, not an AND.
CI environment of sqlite_fdw.
diff amd regression.out) are uploaded as artifacts. 7 days later, artifact files will be deleted.
doxypy_v0.4.2
… either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty…
LICENCE
… either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty…
Backup_Slave/Backup_Master *base* state data structure
… only important fact is that higher n means that backup started later. DATA - data about archiving this segmentDATA is arrayref which contains: [0] - epoch of when omnipitr-backup was called [1] -…
Architecture
… grants for least privilege are documented as examples in later releases; v0.1 focuses on semantics. Decision algorithm (v0.1) Load enabled policies matching principal/action/resource globs.
I. Licensing Terms -- Licensed Under The AGPL v3.0+ (Examples Excepted)
0+), or (at your option) any later version, with the exception of all sample program code, sample commands, and sample configuration file components contained in the documentation, whether explicitly…
Glia
… either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty…
G. Isok Licensing Terms -- Licensed Under The AGPL v3.0+ (Examples Excepted)
0+), or (at your option) any later version, with the exception of all sample program code, sample commands, and sample configuration file components contained in the documentation, whether explicitly…
Updating to a New Version of BedquiltDB
5 or later The naming convention for internal utility functions has changed All public functions have been changed to accept jsonb parameters rather than json The find_one function now accepts skip…
Usage
… of this project are only expected to have Visual Studio 2012 or later, developers of the library are required to have Visual Studio 2022 or later, as the library uses C# 10 features in its…
Appendix A. Hints list
2 and later) on the table.NoIndexOnlyScan(table) Forces not to do index only scan on the table. Available for PostgreSQL 9.2 and later.NoBitmapScan(table) Forces not to do bitmap scan on the table.
Appendix A. Hints list
2 and later) on the table.NoIndexOnlyScan(table) Forces not to do index only scan on the table. Available for PostgreSQL 9.2 and later.NoBitmapScan(table) Forces not to do bitmap scan on the table.
Firebird Foreign Data Wrapper for PostgreSQL
firebird_fdw 1.3.0 and later / PostgreSQL 14 and later.CREATE USER MAPPING options firebird_fdw accepts the following options via the CREATE USER MAPPING command: username The Firebird username to…
README
conf or by setting it later SET query_recorder.enabled = true and later disable it by SET query_recorder.enabled = false So you may enable/disable the query recording as needed.
postgresql-debversion
1 and later): CREATE EXTENSION debversion; If you’re upgrading from an earlier version without extension support, then please run CREATE EXTENSION debversion FROM unpackaged; which will add all the…
README_cn
sql 对于 INNER JOIN LATERAL 且 lateral 子查询只是一个标量相关聚合的场景，当前 pg_monetdb 仍会把外层 join 保留在本地。在这个特定模式下，可以安全地改写成标量相关 WHERE 形式，并且已经可以完全下推。参考 lateral_scalar_rewrite_manual.
User-defined-session-infos
… FALSE ); Note: The value of session_info should be valid JSON to later query the session_info column with JSONB operators. Otherwise, the text is converted with to_jsonb which might not produce…
ProvSQL TODO
… polish, and the Contributions / Time-travel modes scheduled for later versions.
README
If you are already using PostgreSQL 8.4 or later, you cannot change to use this package without redistributing your data. To use it, install it into the database by running \i vihash.
User-defined-session-infos
… FALSE ); Note: The value of session_info should be valid JSON to later query the session_info column with JSONB operators. Otherwise, the text is converted with to_jsonb which might not produce…
ADR-001: Agent Policy Language (APL) Design
Cedar interop can be added later via import/export subset. Must document clearly that APL is not core SQL.
H. Acknowledgments and History
It was later incorporated into Babase, part of The Amboseli Baboon Research Project, and enhanced to take advantage of the features in PostgreSQL 9.1.
Database Test 2 (DBT-2) Documentation
0 or later (the latest version is currently available at http://www.opencontent.org/openpub/). Distribution of substantively modified versions of this document is prohibited without the explicit…
Column-Level Lineage in One Function Call
stream_table FROM pgtrickle.pgt_stream_tables st CROSS JOIN LATERAL pgtrickle.stream_table_lineage(st.name) l WHERE l.source_table = 'orders' AND l.
pgspeck
Requires PostgreSQL version 9.1 or later. The extension adds four functions: -- Encrypts a 32-bit plaintext using a 64-bit key. Only the lowermost 32 bits -- of the plaintext are used.
User-defined-session-infos
… FALSE ); Note: The value of session_info should be valid JSON to later query the session_info column with JSONB operators. Otherwise, the text is converted with to_jsonb which might not produce…
TODO
Notas recentes A via experimental para INNER JOIN LATERAL escalar foi publicada em main, junto com o script sql/lateral_scalar_rewrite_manual.
HNSW Callback Boundary Contract
This inventory fixes the boundary that later HNSW storage, WAL, MVCC, and VACUUM work must preserve. It does not claim that the current prototype has implemented those later behaviors.
User-defined-session-infos
… FALSE ); Note: The value of session_info should be valid JSON to later query the session_info column with JSONB operators. Otherwise, the text is converted with to_jsonb which might not produce…
pg_chdb Development Tools
There are currently two files: bear.yml works with Bear 4 and later, the current release bear.json works with Bear 3, which ships with DebianThe compile_commands.json target determines which to use.
C style guide
… public interfaces as these are more difficult to change later. Naming Functions and Types C does not have namespaces. Anywhere you would normally use a namespace separator (::) in C++, we use an…
User-defined-session-infos
… FALSE ); Note: The value of session_info should be valid JSON to later query the session_info column with JSONB operators. Otherwise, the text is converted with to_jsonb which might not produce…
R2A Checked Resource Policy Evidence
… adaptive byte-bounded batches; this evidence does not claim those later guarantees.
installation
… in the demo database and in template1, so databases created later inherit it. PGXN pgxn install pg_describe Then, in each database that needs it: CREATE EXTENSION pg_describe; From source Building…
DVM Operators
… clause with explicit or implicit LATERAL semantics: FROM t, LATERAL (SELECT ... WHERE ref = t.col) AS alias or FROM t LEFT JOIN LATERAL (...) AS alias ON true.
run()
… - stacks meta info in $self->{'delete_backups'} - to be used later by delete_old_backups single oldest, but within keep-days - puts the meta information in $self->{'oldest_kept'} - to be used later…
Documentation TODO: case-study coverage
CS3: Île-de-France Public Transit LATERAL: for each route, find the next reachable stop with a LATERAL (SELECT ... LIMIT 1). Reads naturally as “what comes after Bagneux on this line”.
Querying with Provenance
… semantics) JOIN (inner joins, outer joins, natural joins) LATERAL subqueries Non-recursive CTEs (WITH clauses) Subqueries in the FROM clause (including deeply nested) GROUP BY SELECT DISTINCT (set…
README
sql For INNER JOIN LATERAL queries whose lateral subquery is just a scalar correlated aggregate, current pg_monetdb behavior is to keep the outer join local.
README_pt_BR
… ); Esse rewrite so eh recomendado para o caso de INNER JOIN LATERAL em que o lado lateral retorna uma unica linha com agregado escalar correlacionado na relacao externa e o predicado do join apenas…
Contributing to pg_later
You will need Docker running. docker build -t local-dev-pg-later . && docker run -it --rm -v $(pwd):/app local-dev-pg-later /bin/bash When the above command completes, you will have a shell inside of…
Internal lazy HNSW cursor
This is an internal foundation for later bounded beam search, not a SQL API or a user-selectable planner mode. Contract The cursor owns only traversal state: the pending and nearest heaps, visited…
Installing firebird_fdw on CentOS/Redhat
2.1, firebird_fdw (and libfq) packages for PostgreSQL 10 and later are available via the PostgreSQL community YUM repository; for details see here: https://yum.postgresql.org/.
Installing firebird_fdw on CentOS/Redhat
2.1, firebird_fdw (and libfq) packages for PostgreSQL 10 and later are available via the PostgreSQL community YUM repository; for details see here: https://yum.postgresql.org/.
README
12.0 or later that might not be readily available as a package on all platforms. Installing the latest cmake on OSX: brew install cmake Building and running unit tests using existing make files: $…