Skip site navigation (1) Skip section navigation (2)

Re: Loading functions

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Kieran McCusker <kieran(dot)mccusker(at)kwest(dot)info>
Subject: Re: Loading functions
Date: 2004-08-27 23:37:00
Message-ID: 412FC59C.4090001@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-admin
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;	
BEGIN
	RAISE NOTICE 'look at this string';
         return 0;
END;
$$ LANGUAGE 'plpgsql';


Regards
Gaetano Mendola





In response to

pgsql-admin by date

Next:From: kris palDate: 2004-08-28 03:47:35
Subject: Re: vacuum pg_attribute causes high load
Previous:From: Christopher BrowneDate: 2004-08-27 21:24:54
Subject: Re: vacuum pg_attribute causes high load

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group