Commit243a913

Thomas G. Lockhart

committed

Remove some definitions which could not work; conversions from datetime

to integer unix system time conflict on the input types. Leave in the conversions from integer unix system time to datetime.

1 parent9d99dac commit243a913Copy full SHA for 243a913

File tree

-22

lines changed

-22

lines changed

Lines changed: 2 additions & 22 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,14 +1,14 @@`
`1`	`1`	`-- unixdate`
`2`	`2`	`-- Routines to convert int4 (Unix system time) to datetime`
`3`		`--- and int4 (delta time) to timespan`
	`3`	`+-- and int4 (delta time in seconds) to timespan`
`4`	`4`	`--`
`5`	`5`	`-- Thomas Lockhart (lockhart@alumni.caltech.edu)`
`6`	`6`	`-- 1997-11-25`
`7`	`7`	`--`
`8`	`8`	`-- This cheats and reuses existing code in the standard package.`
`9`	`9`	`-- Can not include this directly because built-in functions are optimized`
`10`	`10`	`-- into a cache and the duplicate function names abstime_datetime() and`
`11`		`--- reltime_timespan() result in duplicate constants.`
	`11`	`+-- reltime_timespan()wouldresult in duplicate constants.`
`12`	`12`	`--`
`13`	`13`	`-- This works with Postgres v6.2 and higher.`
`14`	`14`
`@@ -32,23 +32,3 @@ CREATE FUNCTION timespan(int4)`
`32`	`32`	`RETURNS timespan`
`33`	`33`	`AS'select reltime_timespan($1)' LANGUAGE'SQL';`
`34`	`34`
`35`		`---`
`36`		`--- Conversions back to integer`
`37`		`---`
`38`		`-`
`39`		`-CREATEFUNCTIONdatetime_abstime(datetime)`
`40`		`- RETURNS int4`
`41`		`-AS'-' LANGUAGE'internal';`
`42`		`-`
`43`		`-CREATEFUNCTIONutime(datetime)`
`44`		`- RETURNS int4`
`45`		`-AS'select datetime_abstime($1)' LANGUAGE'SQL';`
`46`		`-`
`47`		`-CREATEFUNCTIONtimespan_reltime(timespan)`
`48`		`- RETURNS int4`
`49`		`-AS'-' LANGUAGE'internal';`
`50`		`-`
`51`		`-CREATEFUNCTIONuspan(timespan)`
`52`		`- RETURNS int4`
`53`		`-AS'select timespan_reltime($1)' LANGUAGE'SQL';`
`54`		`-`

Comments

(0)