Re: Dynamic Query problem

On Fri, 28 Sep 2001, Dinesh Parikh wrote:

> Dear All,

> I am new in postgres there for i have some problems. I am executing
> some type of Business rule in strored procedure using language
> plpgsql. When I am executing a Dynamic Query then It return an error
> which is some how unable to understand Please Help me It is urgent . I
> am attaching my code as well as error which appears to me.

> I have noted that if table has same type of column then no error comes
> .

My guess would be that the offending line is the DBOut := MyRec.field
since when you go from X_1 to X_2 the right hand side changes type.
It probably planned out how to do the assignment/conversion for the
int4 column and then an int8 is there.

> ERROR:  type of myrec.field doesn't match that when preparing the plan