Statistics for MySQL  1.1
 All Classes Files Functions Variables Typedefs Macros Pages
Classes | Functions
rownumber.c File Reference

Determine row number. More...

#include "sqlstat.h"
Include dependency graph for rownumber.c:

Go to the source code of this file.

Classes

struct  rownumber_storage
 Storage for rownumber function. More...
 

Functions

my_bool rownumber_init (UDF_INIT *initid, UDF_ARGS *args, char *message)
 Called before first usage of function. More...
 
long long rownumber (UDF_INIT *initid, UDF_ARGS *args, char *is_null, char *error)
 Retrieve row number. More...
 
void rownumber_deinit (UDF_INIT *initid)
 Called after last access to function. More...
 

Detailed Description

Determine row number.

CREATE FUNCTION rownumber RETURNS INTEGER SONAME 'libsqlstat.so';
SELECT rownumber() FROM mytab;
DROP FUNCTION rownumber;

Definition in file rownumber.c.

Function Documentation

double rownumber ( UDF_INIT *  initid,
UDF_ARGS *  args,
char *  is_null,
char *  error 
)

Retrieve row number.

Parameters
initidfunction description
argsargument values
is_nullresult is NULL
errorerror message
Returns
row number

Definition at line 84 of file rownumber.c.

rownumber_deinit ( UDF_INIT *  initid)

Called after last access to function.

Deallocate memory for counter.

Parameters
initid

Definition at line 104 of file rownumber.c.

my_bool rownumber_init ( UDF_INIT *  initid,
UDF_ARGS *  args,
char *  message 
)

Called before first usage of function.

Checksparameters.
Indicate type of return value.

Parameters
initidfunction description
argsparameters
messageerror message
Returns
success = 0

Definition at line 51 of file rownumber.c.