Re: Numbering rows

D. Dante Lorenso wrote:

> PERL can remember variables in your session.  Here's a function I wrote
> that sets a "global" variable in PL/PERL:

Perl can do anything- that's cheating :-)

Actually, I use Perl heavily but the advantage of being able to do the
sort of analysis being discussed in a single query is that the query can
be easily shipped with the results as a description of the method.
Having to set up ad-hoc extra functions (in addition to those that are
normally in the workflow) can be problematic, particularly if a
recipient of the query only has restricted access.

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]