Re: Bug or Misunderstanding ? Delete...Returning into does not work as I expected

All right, I see, although I don't fully understand why it's "sensible" this way.
I'd say it's perfectly normal to get an error back if I am using a particular construct that expects something back.

I also noticed that it doesn't even put a null value into the variable and frankly this is not so "sensible".

Thanks,
Flavio

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:b1p2kf$8ei$1$830fa78d_at_news.demon.co.uk...
>
> It's normal behaviour.
>
> Simple delete statements are
> allowed to affect zero rows - so it
> would not be sensible to raise an
> error because you have appended
> the RETURNING clause.
>
>
> --
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
Received on Tue Feb 04 2003 - 17:34:20 CST