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@xxxxxxx>, carter ck <carterck32@xxxxxxxxxxx> 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? ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
