2020-05-28 10:12 CEST

View Revisions: Issue #1648

Summary 0001648: PostgreSQL 11 support
Revision 2018-10-24 13:10 by Martijn Tonies
Additional Information - create index "include clause"
https://www.postgresql.org/docs/11/static/sql-createindex.html

- triggers.action_order, triggers.action_reference_old_table, and triggers.action_reference_new_table are now populated
https://www.postgresql.org/docs/11/static/infoschema-tables.html

- new hash functions
https://www.postgresql.org/docs/11/static/functions-binarystring.html#FUNCTIONS-BINARYSTRING-OTHER

- timezone specification in to_char and to_timestamp
https://www.postgresql.org/docs/11/static/functions-formatting.html#FUNCTIONS-FORMATTING-DATETIME-TABLE

- new text search functions ( websearch_to_tsquery() & json(b)_to_tsvector() )
https://www.postgresql.org/docs/11/static/functions-textsearch.html#TEXTSEARCH-FUNCTIONS-TABLE

- CALL statement for stored procedures

- ALTER/DROP ROUTINE, CREATE OPERATOR/TRIGGER should use FUNCTION instead of PROCEDURE





Revision 2018-10-23 10:55 by Martijn Tonies
Additional Information