I compiled and uploaded zip files with latest orafce and plpgsql_check for PostgreSQL 17 and PostgreSQL 18 - I used Microsoft Visual C 2022. Setup: download...

PLPGSQL是PostgreSQL的过程化SQL语言，结合OpenGauss数据库展示其在应用开发中的优势。通过实际操作，学习函数创建、数据读取、SQL编程及触发器集成等关键步骤，适合企业开发者和学生，案例时长约60分钟。

PLPGSQL是PostgreSQL的过程化SQL语言，结合了SQL与编程特性，适合复杂功能开发。本文介绍了PLPGSQL的基本用法，包括函数创建、变量声明、条件控制和循环结构，帮助开发者和学生掌握其应用优势。

PL/pgSQL是PostgreSQL的过程化SQL语言，适合开发复杂数据库功能。本文介绍了PL/pgSQL的基本用法，包括函数创建、数据读取和触发器集成，适合企业开发者和学生，通过实际操作学习高效应用PL/pgSQL。

PL/pgSQL是PostgreSQL的过程化SQL语言，增强了SQL功能，适合开发者和学生。本文介绍了PL/pgSQL的数据库操作，包括游标、函数和触发器的使用，帮助开发者掌握其基本用法和优势。

I compiled and uploaded zip files plpgsql_check for PostgreSQL 16 and PostgreSQL 17 - I used Microsoft Visual C 2022. Setup: download plpgsql_check-2.7.15-x86_64-windows.zip and extract...

Originally the PL/pgSQL was very simple language and integration procedural language with SQL was very primitive. Very specific feature of PL/pgSQL is translation of every expression to SQL....

I compiled and uploaded zip files with latest orafce and plpgsql_check for PostgreSQL 16 and PostgreSQL 17 - I used Microsoft Visual C 2022. Setup: download orafce-4.14.0-x64.zip or...

I compiled and uploaded zip files with latest orafce and plpgsql_check for PostgreSQL 15 and PostgreSQL 16. Setup: download orafce-4.9.3-x64.zip or plpgsql_check-2.7.4-x64.zip and extract...

Ten years ago I did some speed tests of plpgsql. I did same tests on same computer, and now, the plpgsql is about 3-4 times faster. There is still significant overhead against native (without...

2024年1月4日，Tom Lane提交了一个补丁，允许在plpgsql中使用%TYPE和%ROWTYPE后面跟数组修饰符。这提供了一个有用的功能，可以声明一个变量，该变量是另一个变量或表列的类型的数组。这个功能很酷，但可能不会被广泛使用。现在，我们可以很容易地将变量定义为%TYPE或%ROWTYPE的数组。这个功能允许将记录集存储在变量中，以便以后可以重复使用。

I compiled and uploaded zip files with latest orafce and plpgsql_check for PostgreSQL 15 and PostgreSQL 16. Setup: download orafce-4.7.0-x64.zip or plpgsql_check-2.5.4-x64.zip and extract...

I compiled and uploaded zip files with latest orafce and plpgsql_check for PostgreSQL 14 and PostgreSQL 15. Setup: download orafce-4.0.1.zip or plpgsql_check-2.2.5.zip and extract files ...