diff options
| -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; |