Received: from multivac.embryo.se (multivac.embryo.se [195.149.181.2]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g09Gf3B30804 for ; Wed, 9 Jan 2002 11:41:04 -0500 (EST) (envelope-from tobbe@embryo.se) Received: from tuba.embryo.se ([172.16.0.67]) by multivac.embryo.se with esmtp (Exim 3.12 #1 (Debian)) id 16OLn8-0003RD-00 for ; Wed, 09 Jan 2002 17:41:30 +0100 User-Agent: Microsoft-Entourage/10.0.0.1309 Date: Wed, 09 Jan 2002 17:41:26 +0100 Subject: Re: Nested loops and $13 From: Torbj=?ISO-8859-1?B?9g==?=rn Andersson To: Message-ID: In-Reply-To: <7393.1010590638@sss.pgh.pa.us> Mime-version: 1.0 Content-type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id g09Gieg31911 X-Archive-Number: 200201/67 X-Sequence-Number: 6157 > Easiest way to isolate the > problem is to turn on query logging (set debug_print_query = true) > before you run the function for the first time; then look in the > postmaster log to see the passed-down queries. Thanks Tom, I didn't know about that one. And it helped me to find two other errors as well.... Best Regards Torbjörn Andersson --------------------------------------------------- Embryo Communication phone: +46 (0) 31-774 39 11(00) Kungsgatan 7a fax: +46 (0)31 774 07 80 S-411 19 Göteborg mobile: 0708-30 70 04 Sweden home: http://www.embryo.se/ mail: torbjorn.andersson@embryo.se --------------------------------------------------- "Att idag tänka annorlunda än igår skiljer den vise från den envise." — John Steinbeck