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@sss.pgh.pa.us> wrote:
> Culley Harrelson <culleyharrelson@yahoo.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/