Stephan Szabo wrote:
>
> > but I received this as the error:
> > ----------------------------------------------------------
> > ERROR: Unrecognized language specified in a CREATE FUNCTION:
> > 'plpgsql'. Recognized languages are sql, C, internal and the
> > created
> > procedural languages.
> > ----------------------------------------------------------
>
> By default the procedural languages are not loaded. There's a
> script createlang which you can use to load the plpgsql language
> into your database. (If you want it in all future databases,
> I believe if you add it to template1, all later dbs have it
> enabled)
got it.....
and guess what the sample function worked!
Thanks for that..
--
Dale Walker dale@icr.com.au
Independent Computer Retailers (ICR) http://www.icr.com.au
ICRnet http://www.icr.net.au