Re: simple function syntax

Поиск
Список
Период
Сортировка
Искать
От
Culley Harrelson
Тема
Re: simple function syntax
Дата
Msg-id
20010128011216.96946.qmail@web9605.mail.yahoo.com
Список
Дерево обсуждения
Re: simple function syntax Culley Harrelson <culleyharrelson@yahoo.com>
Re: simple function syntax Tom Lane <tgl@sss.pgh.pa.us>
I ran createlang successfully and I'm still getting
compile errors on basic plpgsql functions (sql
functions work).I'm assuming I have to do something
like:

create trusted procedural language plpgsql
handler = ????

do I need to write a handler function for plpgsql?

Boy this is making me feel really lame :)

Culley

--- "Robert B. Easter" 
wrote:
> Load the procedural language from the shell:
> 
> createlang plsql 
> 
> On Friday 26 January 2001 00:55, Culley Harrelson
> wrote:
> > OK trying to write my first function and its
> blowing
> > up at compile.  What's wrong with this:
> >
> > CREATE FUNCTION test_function(int4) RETURNS int4
> AS '
> > 	DECLARE
> > 		test ALIAS FOR $1;
> > 	BEGIN
> > 		RETURN test;
> > 	END;
> > ' LANGUAGE 'plpgsql';
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Auctions - Buy the things you want at great
> prices.
> > http://auctions.yahoo.com/
> 
> -- 
> -------- Robert B. Easter  reaster@comptechnews.com
> ---------
> -- CompTechNews Message Board
> http://www.comptechnews.com/ --
> -- CompTechServ Tech Services
> http://www.comptechserv.com/ --
> ---------- http://www.comptechnews.com/~reaster/
------------


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices. 
http://auctions.yahoo.com/
В списке pgsql-general по дате отправления
От: Rob Arnold
Дата:
Сообщение: Re: MS Excel to PostgreSQL?
От: Tom Lane
Дата:
Сообщение: Re: simple function syntax
FAQ