"Mike G." <[EMAIL PROTECTED]> writes:
> I have a function that reads through one table via a cursor to make updates
> to a different table. There is a row in this table with a column that has a
> null value. The following row, in that same column, is not null.
> When the cursor loops through
thank you.
I use the cursor because I really do an update against a different table based
on a value from the select in the original table. I am eagerly awaiting 8.0
and the ability to issue an Update Table1 Set Table1.col = Table2.col Using
(Select y from Table2)
Mike
On Thu, Jan 13, 2005
On Thu, Jan 13, 2005 at 04:35:04PM -0600, Mike G. wrote:
> thank you.
>
> I use the cursor because I really do an update against a different
> table based on a value from the select in the original table. I am
> eagerly awaiting 8.0 and the ability to issue an Update Table1 Set
> Table1.col = Tab
On Fri, Jan 14, 2005 at 01:28:47PM +0100, Martijn van Oosterhout wrote:
> On Thu, Jan 13, 2005 at 04:35:04PM -0600, Mike G. wrote:
> > thank you.
> >
> > I use the cursor because I really do an update against a different
> > table based on a value from the select in the original table. I am
> > e
On Mon, Jan 17, 2005 at 12:06:56AM -0600, Mike G. wrote:
> It doesn't look like it has been added to the documentation yet. The
> only reference I could find to it was in the todo list (create
> similiar ability for delete statement).
>
> USING allows you to add join statements to your update sta