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   <[EMAIL PROTECTED]>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to 
> litigate.

Attachment: signature.asc
Description: Digital signature

Reply via email to