Hi,
Actually I think there is some type of caching in record datatype. Is there
any way to find datatype of record's column so that i can explicit cast in
assignment(have u propse alternate of this).
Regards
Dinesh
NSTL, New Delhi
----- Original Message -----
From: "Stephan Szabo" <sszabo@megazone23.bigpanda.com>
To: "Dinesh Parikh" <dineshp@newgen.co.in>
Cc: <pgsql-general@postgresql.org>
Sent: Saturday, September 29, 2001 12:02 PM
Subject: Re: [GENERAL] 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