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>
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 |