diff options
Diffstat (limited to 'src/extend/datetime/datetime_functions.sql')
-rw-r--r-- | src/extend/datetime/datetime_functions.sql | 69 |
1 files changed, 0 insertions, 69 deletions
diff --git a/src/extend/datetime/datetime_functions.sql b/src/extend/datetime/datetime_functions.sql deleted file mode 100644 index 2e50a4a19fd..00000000000 --- a/src/extend/datetime/datetime_functions.sql +++ /dev/null @@ -1,69 +0,0 @@ - --- SQL code to load and define 'datetime' functions - --- load the new functions - -load '/home/dz/lib/postgres/datetime_functions.so'; - --- define the new functions in postgres - -create function time_difference(time,time) - returns time - as '/home/dz/lib/postgres/datetime_functions.so' - language 'c'; - -create function currentDate() - returns date - as '/home/dz/lib/postgres/datetime_functions.so' - language 'c'; - -create function currentTime() - returns time - as '/home/dz/lib/postgres/datetime_functions.so' - language 'c'; - -create function hours(time) - returns int4 - as '/home/dz/lib/postgres/datetime_functions.so' - language 'c'; - -create function minutes(time) - returns int4 - as '/home/dz/lib/postgres/datetime_functions.so' - language 'c'; - -create function seconds(time) - returns int4 - as '/home/dz/lib/postgres/datetime_functions.so' - language 'c'; - -create function day(date) - returns int4 - as '/home/dz/lib/postgres/datetime_functions.so' - language 'c'; - -create function month(date) - returns int4 - as '/home/dz/lib/postgres/datetime_functions.so' - language 'c'; - -create function year(date) - returns int4 - as '/home/dz/lib/postgres/datetime_functions.so' - language 'c'; - -create function asMinutes(time) - returns int4 - as '/home/dz/lib/postgres/datetime_functions.so' - language 'c'; - -create function asSeconds(time) - returns int4 - as '/home/dz/lib/postgres/datetime_functions.so' - language 'c'; - -create operator - ( - leftarg=time, - rightarg=time, - procedure=time_difference); - |