Re: order of statements in create function - Mailing list pgsql-general

From Markus Bertheau
Subject Re: order of statements in create function
Date
Msg-id 1089399771.2719.117.camel@teetnang
Whole thread Raw
In response to Re: order of statements in create function  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Responses Re: order of statements in create function
List 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@bluetwanger.de>


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: order of statements in create function
Next
From: Bruce Momjian
Date:
Subject: Re: will this bug be fixed in 7.5