. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 336 6.6.2. Examples of MERGE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 340 6.7.2. Examples of EXECUTE PROCEDURE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 341 6.8.1. Examples. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 255 6.7.2. Examples of EXECUTE PROCEDURE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 269 Table of Contents 6 7.6. Writing the Body Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . procedural language — procedural SQL (PSQL) — for stored procedures, triggers and dynamically-executable code blocks. These are the areas addressed in this volume. 1.2. Authorship The material for assembling

Calling Conventions Version 1 for C-Language Functions ............................531 32.9.5. Writing Code.................................................................................................. ..........................................................................639 36.11.1. Porting Examples..........................................................................................639 36 ......................................................................................713 40.5. Examples ...............................................................................................

Calling Conventions Version 1 for C-Language Functions ............................491 31.9.5. Writing Code.................................................................................................. ..........................................................................594 35.11.1. Porting Examples..........................................................................................594 35 ......................................................................................665 39.5. Examples ...............................................................................................

....................................................................................187 8.17.2. Examples................................................................................................ ................................................................460 15. Installation from Source Code .................................................................................................462 Tracing PostgreSQL..............................................486 16. Installation from Source Code on Windows ............................................................................487 16.1.

Types ...............................................................................176 8.17.2. Examples................................................................................................ ................................................................434 15. Installation from Source Code ..........................................................................................436 15 DTrace for Tracing PostgreSQL.......................................459 16. Installation from Source Code on Windows .....................................................................460 16.1. Building

................................................................ 449 16. Installation from Source Code ......................................................................... 455 v PostgreSQL 10.23 ................................................................ 472 17. Installation from Source Code on Windows ....................................................... 480 17.1. Building with Visual ............................................................................ 1205 45.5. Anonymous Code Blocks ................................................................... 1205 45.6. Trigger Functions

4. Calling Conventions Version 1 for C-Language Functions .....................464 31.9.5. Writing Code............................................................................................466 31 ..........................................................................561 35.11.1. Porting Examples...................................................................................561 35.11.2. Other Changes....................................................................................629 39.5. Examples ...............................................................................................

................................................................ 473 16. Installation from Source Code .............................................................................. 479 16.1. Short Version ................................................................ 497 17. Installation from Source Code on Windows ............................................................ 505 17.1. Building with Visual ............................................................................ 1272 45.5. Anonymous Code Blocks ........................................................................ 1272 45.6. Trigger

Calling Conventions Version 1 for C-Language Functions ............................528 32.9.5. Writing Code.................................................................................................. ..........................................................................635 36.11.1. Porting Examples..........................................................................................636 36 ......................................................................................709 40.5. Examples ...............................................................................................