Re: Set a rowcount limit

Posted in 1999

Willem Roos — Tue, 16 Feb 1999 09:40:10 +0200 — source: Informix-list mailing list archive (1991-1998)

Just looking for trouble :-) Sean Kelsey wrote: > > SELECT FIRST 10 col1, col2, col3 > FROM table;> Isn't this very un-relational? Shouldn't one use a cursor in this case? -- /* ----------------------------------------------------- * * Willem Roos wroos@shoprite.co.za * * roosj@mweb.co.za * * 0(+27)21 980 4941 * * 0(+27)21 919 0198 * * ----------------------------------------------------- */

↪ replying to Willem Roos

Sean Kelsey — Tue, 16 Feb 1999 10:37:29 -0000 — source: Informix-list mailing list archive (1991-1998)

Yes you could (rolling up shirt sleeves) The words 'cat' and 'skin' and 'many' come to mind !! Cursors could be better, but of course it would totally depend on the application that it was going to be used for ! ( squaring up, eyes widening ) p.s. I'm wearing glasses Willem Roos wrote in message <7ab9fb$h19$1@news.xmission.com>... > >Just looking for trouble :-) > >Sean Kelsey wrote: >> >> SELECT FIRST 10 col1, col2, col3 >> FROM table;>> > >Isn't this very un-relational? Shouldn't one use a cursor in this case? > >-- >/* ----------------------------------------------------- * > * Willem Roos wroos@shoprite.co.za * > * roosj@mweb.co.za * > * 0(+27)21 980 4941 * > * 0(+27)21 919 0198 * > * ----------------------------------------------------- */