Thread: Loading functions

Loading functions

From
"Kieran McCusker"
Date:
Hi

My biggest bugbear with Postgresql is the double quoting when writing
functions.  Has anyone suggested a possible syntax such as :-

create or replace function sp_AddContact(varchar)
returns integer from '<filename>' LANGUAGE 'plpgsql';

This would remove the issue with parsing for begin...ends (or whatever the
language was using)

Just a thought

Kieran


Re: Loading functions

From
Gaetano Mendola
Date:
Kieran McCusker wrote:

> Hi
>
> My biggest bugbear with Postgresql is the double quoting when writing
> functions.  Has anyone suggested a possible syntax such as :-
>
> create or replace function sp_AddContact(varchar)
> returns integer from '<filename>' LANGUAGE 'plpgsql';

No, but in the near future with 8.0 version you can:

create or replace function sp_AddContact(varchar)
returns integer AS $$
DECLARE   a ALIAS FOR $1;
BEGINRAISE NOTICE 'look at this string';        return 0;
END;
$$ LANGUAGE 'plpgsql';


Regards
Gaetano Mendola