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. All helps are appreciated. Thanks. _________________________________________________________________ Manage multiple email accounts with Windows Live Mail! http://www.get.live.com/wl/all ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
