Re: Column COMMENTs in CREATE TABLE?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Column COMMENTs in CREATE TABLE?
Дата
Msg-id 9035775f-42a2-f800-5f9e-25f36cb13f00@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: Column COMMENTs in CREATE TABLE?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Column COMMENTs in CREATE TABLE?  (David Fetter <david@fetter.org>)
Список pgsql-hackers
On 7/3/16 11:41 AM, Tom Lane wrote:
> I can see the reasoning for
> allowing COMMENT in a table column definition, but the argument for
> allowing it in simpler CREATEs seems tissue-thin:
> 
>     CREATE FUNCTION foo(int) RETURNS ... ;
>     COMMENT ON FUNCTION foo(int) IS 'blah';
> 
> vs
> 
>     CREATE FUNCTION foo(int) RETURNS ...
>     WITH (COMMENT 'blah');
> 
> Not much of a keystroke savings, nor is the comment noticeably
> "closer" to its object than before.

I had actually been thinking about a similar proposal, but specifically
for CREATE FUNCTION.  But the syntax would have to put it above the
function body, not below it.  I think the CREATE FUNCTION syntax could
actually handle that.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: regression test for extended query protocol
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Bogus ANALYZE results for an otherwise-unique column with many nulls