Anton Melser wrote:
> I need to analyse some html to get some links out, and with only 25
> lines in exports_tmp_links (and text_to_parse no more than around
> 10KB) this function has taken 10 minutes and counting. Something
> horribly wrong is going on here! Can someone give me any pointers?
I bet that you are running into an endless loop there.
Try adding a few RAISE statements to find out what is happening,
RAISE NOTICE 'I am here, and myvar = % and thatvar = %', myvar, thatvar;
In response to
pgsql-general by date
|Next:||From: Robert Partyka||Date: 2007-02-27 11:15:03|
|Subject: strange behaviour with sub-select and pl/pgSQL|
|Previous:||From: Vegard Bønes||Date: 2007-02-27 07:58:19|
|Subject: SQL names for C constants|