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

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.

The first used to be the only allowed order, before we made it more
flexible, as specified by the SQL standard.