Re:

[Martijn van Oosterhout <kleptog(at)svana(dot)org>]

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(at)svana(dot)org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment: signature.asc
Description: Digital signature