Set Returning Functions
  • References/Database/PostgreSQL/Functions and Operators

This section describes functions that possibly return more than one row. The most widely used functions in this class are series generating functions, as detailed in Table

2025-01-10 15:47:30
2.
  • References/Database/PostgreSQL/Tutorial/The SQL Language

PostgreSQL is a relational database management system (RDBMS). That means it is

2025-01-10 15:47:30
Pseudo-Types
  • References/Database/PostgreSQL/Data Types

The PostgreSQL type system contains a number of special-purpose entries that are collectively called pseudo-types

2025-01-10 15:47:30
Operator Classes and Operator Families
  • References/Database/PostgreSQL/Indexes

An index definition can specify an operator class for each column of an index.

2025-01-10 15:47:30
Full Text Search: Dictionaries
  • References/Database/PostgreSQL/Full Text Search

Dictionaries are used to eliminate words that should not be considered in a search (stop words), and to normalize words so

2025-01-10 15:47:30
Combining Multiple Indexes
  • References/Database/PostgreSQL/Indexes

A single index scan can only use query clauses that use the index's columns with operators of its operator class and are joined with AND. For example

2025-01-10 15:47:30
Catalogs: pg_ts_template
  • References/Database/PostgreSQL/Internals: Catalogs

The pg_ts_template catalog contains entries defining text search templates. A template is the implementation skeleton for a class of text search

2025-01-10 15:47:30
DROP GROUP
  • References/Database/PostgreSQL/Commands

NameDROP GROUP -- remove a database role Synopsis

2025-01-10 15:47:30
Catalogs: pg_statistic
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_statistic stores statistical data about the contents of the database. Entries are created by

2025-01-10 15:47:30
DROP CAST
  • References/Database/PostgreSQL/Commands

NameDROP CAST -- remove a cast Synopsis

2025-01-10 15:47:30