Re: order of statements in create function

Поиск
Список
Период
Сортировка
От Markus Bertheau
Тема Re: order of statements in create function
Дата
Msg-id 1089399771.2719.117.camel@teetnang
обсуждение исходный текст
Ответ на Re: order of statements in create function  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Ответы Re: order of statements in create function  (Robert Treat <robtreat@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: order of statements in create function
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: will this bug be fixed in 7.5