On Wed, Oct 31, 2007 at 11:07:36AM +0800, carter ck wrote:
> Hi all,
>
> I was trying to create function in postgres, but it returns error mentioning the language is NOT defined.
<snip>
> ERROR: language "plpgsql" does not exist
> HINT: Use CREATE LANGUAGE to load the language into the database.
>
> I was wonderring why it is not included by default? Or have I missed out something in the configuration!
It's included by default, just not enabled by default. Try "create
language plpgsql" as administrator.
> Also, how to do a better text search? I have come across the bad performance of LIKE statement.
See tsearch2.
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.