Re: Is there a bug in FOR i IN 1..10 LOOP (8.4.4)?

From: "Rob Richardson" <Rob(dot)Richardson(at)rad-con(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Is there a bug in FOR i IN 1..10 LOOP (8.4.4)?
Date: 2010-09-13 12:59:06
Message-ID: 04A6DB42D2BA534FAC77B90562A6A03D0155474B@server.rad-con.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


What makes you think there is a bug? What does this function return for
you? It always helps us to see everything you have seen.

Without taking the time to try it on my system, I'd recommend explictly
converting your index to text:
num_var := num_var || ',' || i::text;

RobR

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-09-13 14:41:00 Re: Query plan choice issue
Previous Message Merlin Moncure 2010-09-13 12:30:38 Re: How to inherit search_path from template