Re: [GENERAL]

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


application/pgp-signature attachment: Digital signature