Skip site navigation (1) Skip section navigation (2)

Re: Dynamic Query problem

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Dinesh Parikh <dineshp(at)newgen(dot)co(dot)in>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Dynamic Query problem
Date: 2001-09-29 06:32:21
Message-ID: Pine.BSF.4.21.0109282330180.29157-100000@megazone23.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
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


In response to

Responses

pgsql-novice by date

Next:From: Dinesh ParikhDate: 2001-09-29 12:22:03
Subject: Re: Dynamic Query problem
Previous:From: Stephan SzaboDate: 2001-09-29 06:06:38
Subject: Re: Temporary Table Problem

pgsql-general by date

Next:From: ltDate: 2001-09-29 06:50:26
Subject: Copy error?
Previous:From: Stephan SzaboDate: 2001-09-29 06:06:38
Subject: Re: Temporary Table Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group