| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | lt | 2001-09-29 06:50:26 | Copy error? |
| Previous Message | Stephan Szabo | 2001-09-29 06:06:38 | Re: Temporary Table Problem |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dinesh Parikh | 2001-09-29 12:22:03 | Re: Dynamic Query problem |
| Previous Message | Stephan Szabo | 2001-09-29 06:06:38 | Re: Temporary Table Problem |