Template:Postgres function installation - Revision history

Steve: Reverted edits by Anecada (Talk) to last revision by Steve

2010-11-24T14:00:10Z

Reverted edits by Anecada (Talk) to last revision by Steve

← Older revision		Revision as of 14:00, 24 November 2010
Line 1:		Line 1:
	~~=[http://aduratutuz.co.cc Under Construction! Please Visit Reserve Page. Page Will Be Available Shortly]=~~

	-- cut and paste the following SQL to register the functions into postgres --		-- cut and paste the following SQL to register the functions into postgres --

Anecada at 02:10, 24 November 2010

2010-11-24T02:10:49Z

← Older revision		Revision as of 02:10, 24 November 2010
Line 1:		Line 1:
			=[http://aduratutuz.co.cc Under Construction! Please Visit Reserve Page. Page Will Be Available Shortly]=

	-- cut and paste the following SQL to register the functions into postgres --		-- cut and paste the following SQL to register the functions into postgres --

Steve at 17:10, 8 September 2010

2010-09-08T17:10:26Z

← Older revision		Revision as of 17:10, 8 September 2010
Line 1:		Line 1:
	~~'''NB Execute the following on the EXODUS database.'''~~

	-- cut and paste the following SQL to register the functions into postgres --		-- cut and paste the following SQL to register the functions into postgres --

Steve at 17:03, 8 September 2010

2010-09-08T17:03:34Z

← Older revision		Revision as of 17:03, 8 September 2010
Line 1:		Line 1:
	'''NB Execute the following on the ~~exodus~~ database.'''		'''NB Execute the following on the EXODUS database.'''

	-- cut and paste the following SQL to register the functions into postgres --		-- cut and paste the following SQL to register the functions into postgres --

Steve at 17:03, 8 September 2010

2010-09-08T17:03:22Z

← Older revision		Revision as of 17:03, 8 September 2010
Line 1:		Line 1:
	Execute the following on the exodus database.		'''NB Execute the following on the exodus database.'''

	-- cut and paste the following SQL to register the functions into postgres --		-- cut and paste the following SQL to register the functions into postgres --

Steve at 17:01, 8 September 2010

2010-09-08T17:01:50Z

← Older revision		Revision as of 17:01, 8 September 2010
Line 1:		Line 1:
			Execute the following on the exodus database.

	-- cut and paste the following SQL to register the functions into postgres --		-- cut and paste the following SQL to register the functions into postgres --

Steve at 21:53, 5 July 2009

2009-07-05T21:53:06Z

← Older revision		Revision as of 21:53, 5 July 2009
Line 1:		Line 1:
	-- ~~The latest version of this can be found in pgexodus.c~~		-- cut and paste the following SQL to register the functions into postgres --

	CREATE OR REPLACE FUNCTION exodus_call(bytea, bytea, bytea, bytea, bytea, int4, int4)		CREATE OR REPLACE FUNCTION exodus_call(bytea, bytea, bytea, bytea, bytea, int4, int4) RETURNS bytea
	RETURNS bytea
	AS 'pgexodus', 'exodus_call' LANGUAGE C IMMUTABLE;		AS 'pgexodus', 'exodus_call' LANGUAGE C IMMUTABLE;

Line 8:		Line 7:
	RETURNS bytea AS 'pgexodus', 'exodus_extract_bytea' LANGUAGE C IMMUTABLE;		RETURNS bytea AS 'pgexodus', 'exodus_extract_bytea' LANGUAGE C IMMUTABLE;

	CREATE OR REPLACE FUNCTION exodus_extract_text(bytea, int4, int4, int4)		CREATE OR REPLACE FUNCTION exodus_extract_text(bytea, int4, int4, int4) RETURNS text
	RETURNS text
	AS 'pgexodus', 'exodus_extract_text' LANGUAGE C IMMUTABLE;		AS 'pgexodus', 'exodus_extract_text' LANGUAGE C IMMUTABLE;

	CREATE OR REPLACE FUNCTION exodus_extract_sort(bytea, int4, int4, int4)		CREATE OR REPLACE FUNCTION exodus_extract_sort(bytea, int4, int4, int4) RETURNS text
	RETURNS text
	AS 'pgexodus', 'exodus_extract_sort' LANGUAGE C IMMUTABLE;		AS 'pgexodus', 'exodus_extract_sort' LANGUAGE C IMMUTABLE;

Line 19:		Line 16:
	-- also return NULL if passed zero length strings		-- also return NULL if passed zero length strings

	CREATE OR REPLACE FUNCTION exodus_extract_text2(bytea, int4, int4, int4)		CREATE OR REPLACE FUNCTION exodus_extract_text2(bytea, int4, int4, int4) RETURNS text
	RETURNS text
	AS 'pgexodus', 'exodus_extract_text2' LANGUAGE C IMMUTABLE STRICT;		AS 'pgexodus', 'exodus_extract_text2' LANGUAGE C IMMUTABLE STRICT;

	CREATE OR REPLACE FUNCTION exodus_extract_date(bytea, int4, int4, int4)		CREATE OR REPLACE FUNCTION exodus_extract_date(bytea, int4, int4, int4) RETURNS date
	RETURNS date
	AS 'pgexodus', 'exodus_extract_date' LANGUAGE C IMMUTABLE STRICT;		AS 'pgexodus', 'exodus_extract_date' LANGUAGE C IMMUTABLE STRICT;

	CREATE OR REPLACE FUNCTION exodus_extract_time(bytea, int4, int4, int4)		CREATE OR REPLACE FUNCTION exodus_extract_time(bytea, int4, int4, int4) RETURNS time
	RETURNS time
	AS 'pgexodus', 'exodus_extract_time' LANGUAGE C IMMUTABLE STRICT;		AS 'pgexodus', 'exodus_extract_time' LANGUAGE C IMMUTABLE STRICT;

	CREATE OR REPLACE FUNCTION exodus_extract_datetime(bytea, int4, int4, int4)		CREATE OR REPLACE FUNCTION exodus_extract_datetime(bytea, int4, int4, int4) RETURNS timestamp
	RETURNS timestamp
	AS 'pgexodus', 'exodus_extract_datetime' LANGUAGE C IMMUTABLE STRICT;		AS 'pgexodus', 'exodus_extract_datetime' LANGUAGE C IMMUTABLE STRICT;

Steve at 13:32, 28 May 2009

2009-05-28T13:32:05Z

← Older revision		Revision as of 13:32, 28 May 2009
Line 11:		Line 11:
	RETURNS text		RETURNS text
	AS 'pgexodus', 'exodus_extract_text' LANGUAGE C IMMUTABLE;		AS 'pgexodus', 'exodus_extract_text' LANGUAGE C IMMUTABLE;

			CREATE OR REPLACE FUNCTION exodus_extract_sort(bytea, int4, int4, int4)
			RETURNS text
			AS 'pgexodus', 'exodus_extract_sort' LANGUAGE C IMMUTABLE;

	-- Remaining functions are STRICT therefore never get called with NULLS		-- Remaining functions are STRICT therefore never get called with NULLS

Steve at 21:54, 13 April 2009

2009-04-13T21:54:31Z

← Older revision		Revision as of 21:54, 13 April 2009
Line 1:		Line 1:
	-- The latest version of this can be found in pgexodus.c		-- The latest version of this can be found in pgexodus.c

	CREATE OR REPLACE FUNCTION ~~neo_call~~(bytea, bytea, bytea, bytea, bytea, int4, int4)		CREATE OR REPLACE FUNCTION exodus_call(bytea, bytea, bytea, bytea, bytea, int4, int4)
	RETURNS bytea		RETURNS bytea
	AS 'pgexodus', '~~neo_call~~' LANGUAGE C IMMUTABLE;		AS 'pgexodus', 'exodus_call' LANGUAGE C IMMUTABLE;

	CREATE OR REPLACE FUNCTION ~~neo_extract_bytea~~(bytea, int4, int4, int4)		CREATE OR REPLACE FUNCTION exodus_extract_bytea(bytea, int4, int4, int4)
	RETURNS bytea AS 'pgexodus', '~~neo_extract_bytea~~' LANGUAGE C IMMUTABLE;		RETURNS bytea AS 'pgexodus', 'exodus_extract_bytea' LANGUAGE C IMMUTABLE;

	CREATE OR REPLACE FUNCTION ~~neo_extract_text~~(bytea, int4, int4, int4)		CREATE OR REPLACE FUNCTION exodus_extract_text(bytea, int4, int4, int4)
	RETURNS text		RETURNS text
	AS 'pgexodus', '~~neo_extract_text~~' LANGUAGE C IMMUTABLE;		AS 'pgexodus', 'exodus_extract_text' LANGUAGE C IMMUTABLE;

	-- Remaining functions are STRICT therefore never get called with NULLS		-- Remaining functions are STRICT therefore never get called with NULLS
	-- also return NULL if passed zero length strings		-- also return NULL if passed zero length strings

	CREATE OR REPLACE FUNCTION ~~neo_extract_text2~~(bytea, int4, int4, int4)		CREATE OR REPLACE FUNCTION exodus_extract_text2(bytea, int4, int4, int4)
	RETURNS text		RETURNS text
	AS 'pgexodus', '~~neo_extract_text2~~' LANGUAGE C IMMUTABLE STRICT;		AS 'pgexodus', 'exodus_extract_text2' LANGUAGE C IMMUTABLE STRICT;

	CREATE OR REPLACE FUNCTION ~~neo_extract_date~~(bytea, int4, int4, int4)		CREATE OR REPLACE FUNCTION exodus_extract_date(bytea, int4, int4, int4)
	RETURNS date		RETURNS date
	AS 'pgexodus', '~~neo_extract_date~~' LANGUAGE C IMMUTABLE STRICT;		AS 'pgexodus', 'exodus_extract_date' LANGUAGE C IMMUTABLE STRICT;

	CREATE OR REPLACE FUNCTION ~~neo_extract_time~~(bytea, int4, int4, int4)		CREATE OR REPLACE FUNCTION exodus_extract_time(bytea, int4, int4, int4)
	RETURNS time		RETURNS time
	AS 'pgexodus', '~~neo_extract_time~~' LANGUAGE C IMMUTABLE STRICT;		AS 'pgexodus', 'exodus_extract_time' LANGUAGE C IMMUTABLE STRICT;

	CREATE OR REPLACE FUNCTION ~~neo_extract_datetime~~(bytea, int4, int4, int4)		CREATE OR REPLACE FUNCTION exodus_extract_datetime(bytea, int4, int4, int4)
	RETURNS timestamp		RETURNS timestamp
	AS 'pgexodus', '~~neo_extract_datetime~~' LANGUAGE C IMMUTABLE STRICT;		AS 'pgexodus', 'exodus_extract_datetime' LANGUAGE C IMMUTABLE STRICT;

Steve: New page: -- The latest version of this can be found in pgexodus.c CREATE OR REPLACE FUNCTION neo_call(bytea, bytea, bytea, bytea, bytea, int4, int4) RETURNS bytea AS 'pgexodus', 'neo_call' LANGUAG...

2009-03-31T18:54:15Z

New page: -- The latest version of this can be found in pgexodus.c CREATE OR REPLACE FUNCTION neo_call(bytea, bytea, bytea, bytea, bytea, int4, int4) RETURNS bytea AS 'pgexodus', 'neo_call' LANGUAG...

New page

-- The latest version of this can be found in pgexodus.c

CREATE OR REPLACE FUNCTION neo_call(bytea, bytea, bytea, bytea, bytea, int4, int4)
RETURNS bytea
AS 'pgexodus', 'neo_call' LANGUAGE C IMMUTABLE;

CREATE OR REPLACE FUNCTION neo_extract_bytea(bytea, int4, int4, int4)
RETURNS bytea AS 'pgexodus', 'neo_extract_bytea' LANGUAGE C IMMUTABLE;

CREATE OR REPLACE FUNCTION neo_extract_text(bytea, int4, int4, int4)
RETURNS text
AS 'pgexodus', 'neo_extract_text' LANGUAGE C IMMUTABLE;

-- Remaining functions are STRICT therefore never get called with NULLS
-- also return NULL if passed zero length strings

CREATE OR REPLACE FUNCTION neo_extract_text2(bytea, int4, int4, int4)
RETURNS text
AS 'pgexodus', 'neo_extract_text2' LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION neo_extract_date(bytea, int4, int4, int4)
RETURNS date
AS 'pgexodus', 'neo_extract_date' LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION neo_extract_time(bytea, int4, int4, int4)
RETURNS time
AS 'pgexodus', 'neo_extract_time' LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION neo_extract_datetime(bytea, int4, int4, int4)
RETURNS timestamp
AS 'pgexodus', 'neo_extract_datetime' LANGUAGE C IMMUTABLE STRICT;