Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 03C192E0CA6
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 19 Nov 2007 11:15:40 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 01221-01 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 19 Nov 2007 11:15:40 -0400 (AST)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by postgresql.org (Postfix) with ESMTP id 855942E09A2
	for <pgsql-sql@postgresql.org>; Mon, 19 Nov 2007 11:15:39 -0400 (AST)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by news.hub.org (8.14.1/8.14.1) with ESMTP id lAJFFUHW098108
	for <pgsql-sql@postgresql.org>; Mon, 19 Nov 2007 11:15:30 -0400 (AST)
	(envelope-from news@news.hub.org)
Received: (from news@localhost)
	by news.hub.org (8.14.1/8.14.1/Submit) id lAJEmAkr090756
	for pgsql-sql@postgresql.org; Mon, 19 Nov 2007 10:48:10 -0400 (AST)
	(envelope-from news)
From: "Sabin Coanda" <sabin.coanda@deuromedia.ro>
X-Newsgroups: pgsql.sql
Subject: Re: EXPLAIN ANALYZE inside functions
Date: Mon, 19 Nov 2007 16:48:20 +0200
Organization: Hub.Org Networking Services
Lines: 14
Message-ID: <fhs7n9$2ok2$1@news.hub.org>
References: <fhs2cd$1aqs$1@news.hub.org>
X-Complaints-To: usenet@news.hub.org
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
To: pgsql-sql@postgresql.org
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200711/91
X-Sequence-Number: 29619

>
> Do you know a workaround to do this ?
>

I just succeeded adding the following code:

FOR rec IN EXECUTE 'EXPLAIN ANALYZE ' || sSQL LOOP
        RAISE NOTICE ' - %', rec;
END LOOP;

Regards,
Sabin