Re: order of statements in create function

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: order of statements in create function
Date: 2004-07-09 19:02:51
Message-ID: 1089399771.2719.117.camel@teetnang
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

В Птн, 09.07.2004, в 20:24, Alvaro Herrera пишет:
> On Fri, Jul 09, 2004 at 07:16:14PM +0200, Markus Bertheau wrote:
>
> > why does everyone write
> >
> > CREATE FUNCTION foo() RETURNS INTEGER AS '
> > blah blah
> > ' LANGUAGE 'plpgsql';
> >
> > I've never seen for example:
> >
> > CREATE FUNCTION foo()
> > RETURNS INTEGER
> > LANGUAGE 'plpgsql'
> > AS '
> > blah blah
> > ';
> >
> > Is there a special reason to this? I have a hard time believing that
> > everyone does it the same way by coincidence.
>
> I think previous versions only allowed the language specification at the
> end. I got used to putting it before the function text though, so if
> you are able to read something written by me you'd see that.
>
> That was your point, wasn't it?

Yes, it was. Thanks to you and Peter for explaining it.

--
Markus Bertheau <twanger(at)bluetwanger(dot)de>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2004-07-09 19:38:10 Re: will this bug be fixed in 7.5
Previous Message Peter Eisentraut 2004-07-09 18:46:38 Re: order of statements in create function