From: | "Christian Rengstl" <Christian(dot)Rengstl(at)klinik(dot)uni-regensburg(dot)de> |
---|---|
To: | "carter ck" <carterck32(at)hotmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: |
Date: | 2007-10-31 07:21:45 |
Message-ID: | 47283847.90AD.0080.0@klinik.uni-regensburg.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Universitätsklinikum Regensburg
B3 1.388
Franz-Josef-Strauss-Allee 11
93053 Regensburg
Tel.: +49-941-944-7230
>>> On Wed, Oct 31, 2007 at 4:07 AM, in message
<BAY101-W1511B7A0AA605D61D8630BD5930(at)phx(dot)gbl>, carter ck
<carterck32(at)hotmail(dot)com> wrote:
> Hi all,
>
> I was trying to create function in postgres, but it returns error
mentioning
> the language is NOT defined.
>
> The function is as following:
>
> CREATE OR REPLACE FUNCTION test_word_count(TEXT, TEXT) RETURNS
INTEGER AS $$
> DECLARE
> d_word ALIAS FOR $1;
> d_phrase ALIAS FOR $2;
> BEGIN
> IF d_word IS NULL OR d_phrase IS NULL THEN RETURN 0;
>
> RETURN 1;
>
> END;
>
> $$ LANGUAGE plpgsql;
>
> 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!
>
> Also, how to do a better text search? I have come across the bad
performance
> of LIKE statement.
Have you tried TSearch2 to do a text search?
From | Date | Subject | |
---|---|---|---|
Next Message | Reg Me Please | 2007-10-31 07:41:44 | Re: |
Previous Message | Martijn van Oosterhout | 2007-10-31 07:21:08 | Re: |