File: debversion--unpackaged--1.0.5.sql

package info (click to toggle)
postgresql-debversion 1.1.1-2
  • links: PTS, VCS
  • area: main
  • in suites: buster
  • size: 172 kB
  • sloc: sql: 353; cpp: 159; makefile: 29; sh: 12
file content (57 lines) | stat: -rw-r--r-- 3,007 bytes parent folder | download | duplicates (8)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
--- Debian version type and operators                                -*- sql -*-
---
--- Copyright © 2011 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/>.


ALTER EXTENSION debversion ADD TYPE debversion;

ALTER EXTENSION debversion ADD FUNCTION debversionin(cstring);
ALTER EXTENSION debversion ADD FUNCTION debversionout(debversion);
ALTER EXTENSION debversion ADD FUNCTION debversionrecv(internal);
ALTER EXTENSION debversion ADD FUNCTION debversionsend(debversion);

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

ALTER EXTENSION debversion ADD CAST (bpchar AS debversion);
ALTER EXTENSION debversion ADD CAST (varchar AS debversion);
ALTER EXTENSION debversion ADD CAST (text AS debversion);
ALTER EXTENSION debversion ADD CAST (debversion AS bpchar);
ALTER EXTENSION debversion ADD CAST (debversion AS varchar);
ALTER EXTENSION debversion ADD CAST (debversion AS text);

ALTER EXTENSION debversion ADD OPERATOR > (debversion, debversion);
ALTER EXTENSION debversion ADD OPERATOR >= (debversion, debversion);
ALTER EXTENSION debversion ADD OPERATOR <= (debversion, debversion);
ALTER EXTENSION debversion ADD OPERATOR < (debversion, debversion);
ALTER EXTENSION debversion ADD OPERATOR <> (debversion, debversion);
ALTER EXTENSION debversion ADD OPERATOR = (debversion, debversion);

ALTER EXTENSION debversion ADD AGGREGATE max(debversion);
ALTER EXTENSION debversion ADD AGGREGATE min(debversion);

ALTER EXTENSION debversion ADD OPERATOR CLASS debversion_ops USING hash;
ALTER EXTENSION debversion ADD OPERATOR CLASS debversion_ops USING btree;