SQL:2008 CURRENT_CATALOG and CURRENT_SCHEMA

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: SQL:2008 CURRENT_CATALOG and CURRENT_SCHEMA
Date: 2008-10-22 14:15:15
Message-ID: 48FF3573.7020500@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Here is another patch for relatively redundant SQL:2008 functionality.
They standardized in CURRENT_CATALOG and CURRENT_SCHEMA (without
parentheses, as usual) for what we have as current_database() and
current_schema(). They also added SET CATALOG and SET SCHEMA. SET
CATALOG won't work in PostgreSQL, and SET SCHEMA is a subset of SET
search_path.

Attachment Content-Type Size
sql2008-current-catalog-schema.diff text/plain 9.2 KB

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2008-10-22 14:18:29 Re: Deriving Recovery Snapshots
Previous Message Simon Riggs 2008-10-22 14:11:07 Re: Bitmap Indexes: request for feedback