diff options
author | Marc G. Fournier <scrappy@hub.org> | 1998-04-22 04:16:46 +0000 |
---|---|---|
committer | Marc G. Fournier <scrappy@hub.org> | 1998-04-22 04:16:46 +0000 |
commit | 5b4b3d563d0db16a00909a64090efa877593cffd (patch) | |
tree | 4bef5f89584c3ed96c1fcb47380a89db65154833 /contrib/datetime/datetime_functions.sql | |
parent | 2201d48ccdf79314c3123febf11f5a5d39b7a0b4 (diff) | |
download | postgresql-5b4b3d563d0db16a00909a64090efa877593cffd.tar.gz postgresql-5b4b3d563d0db16a00909a64090efa877593cffd.zip |
From: Jun Kuwamura <juk@rccm.co.jp>
This patch fix the Makefiles in contrib/{pginterface, spi,
miscutil, int8, ip_and_mac, sequence, soundex, string, userlock,
array, datetime} to install their modules in one directory(lib/modules/).
Diffstat (limited to 'contrib/datetime/datetime_functions.sql')
-rw-r--r-- | contrib/datetime/datetime_functions.sql | 75 |
1 files changed, 0 insertions, 75 deletions
diff --git a/contrib/datetime/datetime_functions.sql b/contrib/datetime/datetime_functions.sql deleted file mode 100644 index 955377909a2..00000000000 --- a/contrib/datetime/datetime_functions.sql +++ /dev/null @@ -1,75 +0,0 @@ -func=$1 -cat <<% > datetime_functions.sql -drop function time_difference(time,time); -drop function currentdate(); -drop function currenttime(); -drop function hours(time); -drop function minutes(time); -drop function seconds(time); -drop function day(date); -drop function month(date); -drop function year(date); -drop function asminutes(time); -drop function asseconds(time); -drop operator - (time,time); - -create function time_difference(time,time) - returns time - as '$func' - language 'c'; - -create function currentdate() - returns date - as '$func' - language 'c'; - -create function currenttime() - returns time - as '$func' - language 'c'; - -create function hours(time) - returns int4 - as '$func' - language 'c'; - -create function minutes(time) - returns int4 - as '$func' - language 'c'; - -create function seconds(time) - returns int4 - as '$func' - language 'c'; - -create function day(date) - returns int4 - as '$func' - language 'c'; - -create function month(date) - returns int4 - as '$func' - language 'c'; - -create function year(date) - returns int4 - as '$func' - language 'c'; - -create function asminutes(time) - returns int4 - as '$func' - language 'c'; - -create function asseconds(time) - returns int4 - as '$func' - language 'c'; - -create operator - ( - leftarg=time, - rightarg=time, - procedure=time_difference); -% |