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

Re: Adding column comment to information_schema.columns

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jochem van Dieten <jochemd(at)gmail(dot)com>
Cc: Hannu Krosing <hannu(at)tm(dot)ee>,PostgreSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Adding column comment to information_schema.columns
Date: 2004-07-03 02:51:56
Message-ID: 16194.1088823116@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Jochem van Dieten <jochemd(at)gmail(dot)com> writes:
> 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,

Um ... actually that's not what it says:

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

This refers to keywords, NOT to column names which are just identifiers.
It may be that the SQL committee does not intend to standardize any
information_schema column names that end with underscore, but this
particular note certainly doesn't promise that.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2004-07-03 02:59:11
Subject: Re: Nested Transactions, Abort All
Previous:From: Abhijit Menon-SenDate: 2004-07-03 02:50:17
Subject: Re: PREPARE and transactions

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