Re: Column COMMENTs in CREATE TABLE?

On Fri, Aug 05, 2016 at 10:14:21AM -0400, Peter Eisentraut wrote:
> 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.

For what it's worth, I tend to put the function body last. That's
just my taste, though. Would it be hard to keep the ability to
permute the stuff after

CREATE FUNCTION (args)
RETURNS [SETOF] type

as we have it now?

Best,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate