From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | carter ck <carterck32(at)hotmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: |
Date: | 2007-10-31 07:21:08 |
Message-ID: | 20071031072108.GA21567@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
From | Date | Subject | |
---|---|---|---|
Next Message | Christian Rengstl | 2007-10-31 07:21:45 | Re: |
Previous Message | Ron St-Pierre | 2007-10-31 04:50:13 | Re: |