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

initid	function description
args	argument values
is_null	result is NULL
error	error 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

initid	function description
args	parameters
message	error message

Returns

success = 0

Definition at line 51 of file rownumber.c.