Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/unixdate/unixdate.sql')
-rw-r--r--contrib/unixdate/unixdate.sql34
1 files changed, 0 insertions, 34 deletions
diff --git a/contrib/unixdate/unixdate.sql b/contrib/unixdate/unixdate.sql
deleted file mode 100644
index c78403ba6bb..00000000000
--- a/contrib/unixdate/unixdate.sql
+++ /dev/null
@@ -1,34 +0,0 @@
--- unixdate
--- Routines to convert int4 (Unix system time) to datetime
--- and int4 (delta time in seconds) to timespan
---
--- Thomas Lockhart (lockhart@alumni.caltech.edu)
--- 1997-11-25
---
--- This cheats and reuses existing code in the standard package.
--- Can not include this directly because built-in functions are optimized
--- into a cache and the duplicate function names abstime_datetime() and
--- reltime_timespan() would result in duplicate constants.
---
--- This works with Postgres v6.2 and higher.
-
---
--- Conversions from integer to datetime
---
-
-CREATE FUNCTION abstime_datetime(int4)
- RETURNS datetime
- AS '-' LANGUAGE 'internal';
-
-CREATE FUNCTION datetime(int4)
- RETURNS datetime
- AS 'select abstime_datetime($1)' LANGUAGE 'SQL';
-
-CREATE FUNCTION reltime_timespan(int4)
- RETURNS timespan
- AS '-' LANGUAGE 'internal';
-
-CREATE FUNCTION timespan(int4)
- RETURNS timespan
- AS 'select reltime_timespan($1)' LANGUAGE 'SQL';
-