| From: | Ron St-Pierre <rstpierre(at)syscor(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Function Returning SETOF Problem |
| Date: | 2003-12-18 18:19:57 |
| Message-ID: | 3FE1EFCD.4020006@syscor.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Stephan Szabo wrote:
<snip>
>For the first one, you're making a query string that has lines like
> foo = rec.bar
>where you really want
> foo = <value of rec.bar>
>
>So for execute you want something like
> '' ... foo = '' || rec.bar || '' ... ''
>(possibly requiring casts)
>
>
</snip>
Okay, fixed that ...
<snip>
>As Tom said, this looks like something else. Do you have a rule on
>currentlist that also does an update on currentlist, perhaps forcing
>certain values or something?
>
>
</snip>
Yes, I did have a rule on the table which I had completely forgotten about. I removed it and the function works properly now.
Thanks Stephan and Tom!
Ron
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2003-12-18 18:34:58 | Re: How to navigate tree without CONNECT BY? |
| Previous Message | Tom Lane | 2003-12-18 17:49:49 | Re: restore error - language "plperlu" is not trusted |