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

"kn" <keldn_at_kill.spam> wrote in message
news:3e4040f0$0$184$edfadb0f_at_dread16.news.tele.dk...
> <snip>
> >
> > I agree, both are perfectly legimitate.
> >
> > However,
> >
> > Select salary from emp where 0=1;
> >
> > is also perfectly legimitate, yet it throws a 'no data found'
> > exception at runtime if you add the 'into':
> >
> > Select salary into sal from emp where 0=1;
> >
> > I would have thought that a 'returning...into' would behave the same
> > as 'select...into' does. It may be normal, but it doesn't seem
> > particularly intuitive or consistent.
> >
> then an update returning of say 3 rows. should raise to_many_rows ?
>

Exactly, because that is what happens if you perform a SELECT ... INTO, so why not ?
It'd perfectly acceptable.

Flavio Received on Tue Feb 04 2003 - 17:27:44 CST