Re: Query very slow when in plpgsql function - Mailing list pgsql-general

From Chris McDonald
Subject Re: Query very slow when in plpgsql function
Date
Msg-id 47df9c9a-ce04-44ca-9c25-7d0c34343fbe@m26g2000yqb.googlegroups.com
Whole thread Raw
In response to Query very slow when in plpgsql function  (Chris McDonald <chrisjonmcdonald@gmail.com>)
List pgsql-general
Thanks for your assistance guys, and special thanks to Greg for his
blog page.
This is exactly my problem which is resolved using dynamic SQL. I can
now see how the function was behaving badly, and have been able to fix
the query.

Once again, thanks guys - and Happy New Year from a snow-covered part
of the UK.

chris

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error during make when installing geos for postgis install...still trying
Next
From: benoît carpentier
Date:
Subject: Benetl, a free ETL tool for files using postgreSQL, is out in version 3.3