From: | "A B" <gentosaker(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Problem with FOUND |
Date: | 2008-06-27 08:07:40 |
Message-ID: | dbbf25900806270107r3f3cfd6o3fb798d2854d3e09@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> I think you'd be well advised to rethink your table layout so you don't
> need so much dynamic SQL. The above is going to suck on both
> performance and readability grounds, and it doesn't look like it's
> accomplishing anything you couldn't do by combining all the Rating
> tables into one table with an extra key column.
Yes, it sucks, but I have to live with it right now (I've also removed
a lot of code from the function to make it more readable for you)
There are a lot of other parameters and execute commands :-(
Since I don't run >=8.2 I cant use FOR-EXECUTE-UPDATE-RETURNING.
So I will have to find another way.
But if UPDATE sets FOUND, what is the reason for EXECUTE not to set
FOUND if the query executed is an UPDATE?
Is it because it is impossible to tell in advance what kind of query
an EXECUTE statement will acctually execute?
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2008-06-27 08:33:07 | Re: Problem with FOUND |
Previous Message | Dean Rasheed | 2008-06-27 08:06:58 | Re: what are rules for? |