Re: problem with plpgsql

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Pascal Bourguignon <pjb(at)informatimago(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: problem with plpgsql
Date: 2001-08-20 15:39:02
Message-ID: Pine.BSF.4.21.0108200834200.98666-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, 17 Aug 2001, Pascal Bourguignon wrote:

>
> I've got the following problem with a plpgsql function. I believe it
> denotes a bug with plpgsql.

The problem is that you're trying to compare a space padded char
with a non-space padded text so it's not finding the row. I believe
either defining the columns as text or using rtrim(col) in the where
clauses will solve your problem.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Pascal Bourguignon 2001-08-20 15:50:53 Re: problem with plpgsql
Previous Message Tom Lane 2001-08-20 15:25:42 Re: user authentication crash