Re: problem with plpgsql - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: problem with plpgsql
Date
Msg-id Pine.BSF.4.21.0108200834200.98666-100000@megazone23.bigpanda.com
Whole thread Raw
In response to problem with plpgsql  (Pascal Bourguignon <pjb@informatimago.com>)
List 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.

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Various doc errors and shortcomings
Next
From: Tom Lane
Date:
Subject: Re: user authentication crash