--- Debian version type and operators                                -*- sql -*-
---
--- Copyright © 2008 Roger Leigh <rleigh@debian.org>
---
--- This program is free software: you can redistribute it and/or modify
--- it under the terms of the GNU General Public License as published by
--- the Free Software Foundation, either version 2 of the License, or
--- (at your option) any later version.
---
--- This program is distributed in the hope that it will be useful, but
--- WITHOUT ANY WARRANTY; without even the implied warranty of
--- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
--- General Public License for more details.
---
--- You should have received a copy of the GNU General Public License
--- along with this program.  If not, see
--- <http://www.gnu.org/licenses/>.

DROP OPERATOR CLASS debversion_ops USING btree CASCADE;
DROP OPERATOR CLASS debversion_ops USING hash CASCADE;

DROP AGGREGATE min(debversion);
DROP AGGREGATE max(debversion);

DROP OPERATOR = (debversion, debversion);
DROP OPERATOR <> (debversion, debversion);
DROP OPERATOR < (debversion, debversion);
DROP OPERATOR <= (debversion, debversion);
DROP OPERATOR >= (debversion, debversion);
DROP OPERATOR > (debversion, debversion);

DROP CAST (debversion AS text);
DROP CAST (debversion AS varchar);
DROP CAST (debversion AS bpchar);
DROP CAST (text AS debversion);
DROP CAST (varchar AS debversion);
DROP CAST (bpchar AS debversion);

DROP FUNCTION debversion(bpchar);
DROP FUNCTION debversion_eq(debversion, debversion);
DROP FUNCTION debversion_ne(debversion, debversion);
DROP FUNCTION debversion_lt(debversion, debversion);
DROP FUNCTION debversion_le(debversion, debversion);
DROP FUNCTION debversion_gt(debversion, debversion);
DROP FUNCTION debversion_ge(debversion, debversion);
DROP FUNCTION debversion_cmp(debversion, debversion);
DROP FUNCTION debversion_hash(debversion);
DROP FUNCTION debversion_smaller(debversion, debversion);
DROP FUNCTION debversion_larger(debversion, debversion);

DROP TYPE debversion CASCADE;