RelationalOperators.sql File Reference

The implementantion in sql of Period. More...

Functions
boolean	intersects (period perioda, period periodb)
boolean	contains (period period, timestamp ts)
boolean	contains (period perioda, period periodb)
boolean	containsproperly (period period, timestamp ts)
boolean	containsproperly (period perioda, period periodb)
boolean	after (period period, timestamp ts)
boolean	after (period perioda, period periodb)
boolean	before (period period, timestamp ts)
boolean	before (period perioda, period periodb)
boolean	meets (period period, timestamp ts)
boolean	meets (period perioda, period periodb)
boolean	starts (period perioda, period periodb)
boolean	finishes (period perioda, period periodb)

Detailed Description

The implementantion in sql of Period.

Author

Marios Vodas (mvoda.nosp@m.s@gm.nosp@m.ail.c.nosp@m.om).

Period is a temporal data type used in Hermes

See also

Temporal data types

Function Documentation

boolean after	(	period	period,
		timestamp	ts
	)

boolean after	(	period	perioda,
		period	periodb
	)

boolean before	(	period	period,
		timestamp	ts
	)

boolean before	(	period	perioda,
		period	periodb
	)

boolean contains	(	period	period,
		timestamp	ts
	)

boolean contains	(	period	perioda,
		period	periodb
	)

boolean containsproperly	(	period	period,
		timestamp	ts
	)

boolean containsproperly	(	period	perioda,
		period	periodb
	)

boolean finishes	(	period	perioda,
		period	periodb
	)

boolean intersects	(	period	perioda,
		period	periodb
	)

boolean meets	(	period	period,
		timestamp	ts
	)

boolean meets	(	period	perioda,
		period	periodb
	)

boolean starts	(	period	perioda,
		period	periodb
	)