Skip site navigation (1) Skip section navigation (2)

Re: Adding column comment to information_schema.columns

From: Jochem van Dieten <jochemd(at)gmail(dot)com>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: PostgreSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Adding column comment to information_schema.columns
Date: 2004-07-02 17:50:08
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On Fri, 02 Jul 2004 14:57:18 +0300, Hannu Krosing <hannu(at)tm(dot)ee> wrote:
> IIRC we were recently told (in this thread) that the SQL standard tells
> to end local customisations with underscore, so it would be
> 'column_comment_'

I didn't write that (or at least, I didn't mean to write that :-). The
SQL standard tells that they will not use trailing underscores,
therefore *my* conclusion is that it is future proof (from a standards
perspective) if all PostgreSQL extensions use a trailing underscore.
Which also gives an indication to the user that it is a PostgreSQL

"NOTE 77 - It is the intention that no <key word> specified in ISO/IEC
9075 or revisions thereto shall end with an <underscore>."
ISO/IEC 9075-2:2003   5.4   Names and Identifiers


In response to


pgsql-hackers by date

Next:From: Thomas SwanDate: 2004-07-02 18:37:46
Subject: Re: Nested Transactions, Abort All
Previous:From: Alvaro HerreraDate: 2004-07-02 17:24:00
Subject: Re: Subtle bug in clog.c

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group