Re: simple function syntax

ok the complete error is:

----------------
NOTICE: plpgsql: ERROR during compile of add_one
near line 1
"RROR: parse error near "
----------------

I was trying to select the add_one function in the
documentation.

In the pg_language table I have entries for internal,
c, sql and plpgsql. The plpgsql record reads:

lanname = plpgsql
lanispl = t
lanpltrusted = t
pancallfoid = 19488
lancompiler = PL/pgSQL

the createlang statement I used was:

createlang plpgsql db_name -L /usr/local/pgsql/lib

this is on a new install of slackware 7.1

Culley

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Culley Harrelson <culleyharrelson(at)yahoo(dot)com> writes:
> > 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 = ????
>
> No, createlang should've done that for you.
>
> What do you get from "select * from pg_language" ?
>
> Also, it would help if you mentioned the exact error
> message
> you're getting.
>
> regards, tom lane

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/