File: pg_snakeoil.sql

package info (click to toggle)
pg-snakeoil 1.4-3
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 240 kB
  • sloc: ansic: 193; sql: 26; makefile: 22; sh: 8
file content (25 lines) | stat: -rw-r--r-- 1,044 bytes parent folder | download | duplicates (4)
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
CREATE EXTENSION pg_snakeoil;

-- ------------------------------------------------------------------------
-- Management Functions
-- ------------------------------------------------------------------------

SELECT so_update_signatures();

-- ------------------------------------------------------------------------
-- Text Functions
-- ------------------------------------------------------------------------

SELECT so_is_infected('the quick brown fox jumps over the lazy dog');
SELECT so_virus_name('the quick brown fox jumps over the lazy dog');
SELECT so_is_infected('Hello World!');
SELECT so_virus_name('Hello World!');

-- ------------------------------------------------------------------------
-- bytea Functions
-- ------------------------------------------------------------------------

SELECT so_is_infected('the quick brown fox jumps over the lazy dog'::bytea);
SELECT so_virus_name('the quick brown fox jumps over the lazy dog'::bytea);
SELECT so_is_infected('Hello World!'::bytea);
SELECT so_virus_name('Hello World!'::bytea);