| 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: | Whole Thread | Raw Message | 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: |