[GENERAL]

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!

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

Also, how to do a better text search? I have come across the bad performance of LIKE statement.

All helps are appreciated.

Thanks.

---------------------------(end of broadcast)---------------------------

               http://www.postgresql.org/docs/faq Received on Tue Oct 30 23:12:54 2007