From a4d0f5b898eabfd4ce8a2d05f25a996e2e06c7d2 Mon Sep 17 00:00:00 2001
From: Luca Ferrari <fluca1978@gmail.com>
Date: Mon, 22 Nov 2021 11:14:05 +0100
Subject: Task 1 in PostgreSQL done.

---
 challenge-140/luca-ferrari/postgresql/ch-1.sql | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 challenge-140/luca-ferrari/postgresql/ch-1.sql

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;
-- 
cgit