equal
deleted
inserted
replaced
345 The current version of the driver should be compatible with PostgreSQL 8.2 and higher, and Java 6 |
345 The current version of the driver should be compatible with PostgreSQL 8.2 and higher, and Java 6 |
346 (JDBC 4.0), Java 7 (JDBC 4.1), Java 8 (JDBC 4.2) and Java 9. |
346 (JDBC 4.0), Java 7 (JDBC 4.1), Java 8 (JDBC 4.2) and Java 9. |
347 https://jdbc.postgresql.org/download.html |
347 https://jdbc.postgresql.org/download.html |
348 Java/JDBC/Postgres compatibility table. |
348 Java/JDBC/Postgres compatibility table. |
349 |
349 |
|
350 plpgsql |
|
351 ======= |
|
352 |
|
353 Simple function:: |
|
354 |
|
355 CREATE OR REPLACE FUNCTION incx(x INTEGER) |
|
356 RETURNS INTEGER STABLE AS $$ |
|
357 BEGIN |
|
358 RETURN x + 1; |
|
359 END; |
|
360 $$ LANGUAGE plpgsql; |
|
361 |
|
362 Support for procedures is added only in Postgres v11. |
|
363 |
|
364 https://www.postgresql.org/docs/current/sql-createfunction.html |
|
365 ``CREATE FUNCTION``. |
|
366 https://www.postgresql.org/docs/current/plpgsql-control-structures.html |
|
367 plpgsql control structures. |
|
368 https://www.postgresql.org/docs/current/errcodes-appendix.html |
|
369 PostgreSQL Error Codes. |