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@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
