-
Notifications
You must be signed in to change notification settings - Fork 0
/
README
executable file
·57 lines (26 loc) · 871 Bytes
/
README
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
======================================
This PostgreSQL extension implements a email data type
IMPORTANT: hash c function for hash index is not implementes yet, i do it in plpgsql . I'm working on it and will be releasing another version very soon.
Building
--------
make USE_PGXS=1
sudo make USE_PGXS=1 install
in postgresql execute: create extension email
function
--------
getuser(email) return the user of email
getdomain (emial) return the domain of email
operators
--------
= check that 2 email data are iquals
<> check that 2 email data are diferent
Example
-------
create extension email
create table example (field email)
insert into ejemplo values ('asotolongo@uci.cu')
select * from ejemplo where field1='asotolongo@uci.cu'
select getuser(field1),getdomain(field1) from ejemplo
--
Anthony R. Sotolongo leon
asotolongo@uci.cu