diff options
| author | Luca Ferrari <fluca1978@gmail.com> | 2021-11-22 11:14:05 +0100 |
|---|---|---|
| committer | Luca Ferrari <fluca1978@gmail.com> | 2021-11-22 11:14:05 +0100 |
| commit | a4d0f5b898eabfd4ce8a2d05f25a996e2e06c7d2 (patch) | |
| tree | 2fc77ba123c9aa75b4b07958f8be69f322c9856c | |
| parent | 10537d80ad90a573ba9457e96c307335c5211e46 (diff) | |
| download | perlweeklychallenge-club-a4d0f5b898eabfd4ce8a2d05f25a996e2e06c7d2.tar.gz perlweeklychallenge-club-a4d0f5b898eabfd4ce8a2d05f25a996e2e06c7d2.tar.bz2 perlweeklychallenge-club-a4d0f5b898eabfd4ce8a2d05f25a996e2e06c7d2.zip | |
Task 1 in PostgreSQL done.
| -rw-r--r-- | challenge-140/luca-ferrari/postgresql/ch-1.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/challenge-140/luca-ferrari/postgresql/ch-1.sql b/challenge-140/luca-ferrari/postgresql/ch-1.sql new file mode 100644 index 0000000000..05b9953179 --- /dev/null +++ b/challenge-140/luca-ferrari/postgresql/ch-1.sql @@ -0,0 +1,17 @@ +/** +* Example +testdb=> select f_sum_bits( 10::bit( 10 ), 20::bit( 10 ) ); +f_sum_bits +------------ +0000011110 +(1 row) + +*/ +CREATE OR REPLACE FUNCTION f_sum_bits( a bit(10), b bit(10) ) +RETURNS text +AS $CODE$ + SELECT ( a::int + + b::int )::bit( 10 ); + +$CODE$ +LANGUAGE sql; |