From 95903b6b139186fe0a85fc52df1ce886f04f3e52 Mon Sep 17 00:00:00 2001
From: Luca Ferrari <fluca1978@gmail.com>
Date: Mon, 8 Nov 2021 12:25:03 +0100
Subject: Task 1 done in PostgreSQL

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

diff --git a/challenge-138/luca-ferrari/postgresql/ch-1.sql b/challenge-138/luca-ferrari/postgresql/ch-1.sql
new file mode 100644
index 0000000000..53956e64cb
--- /dev/null
+++ b/challenge-138/luca-ferrari/postgresql/ch-1.sql
@@ -0,0 +1,12 @@
+CREATE OR REPLACE FUNCTION
+  f_working_days_per_year( yy int default extract( year from current_date ) )
+  RETURNS int
+AS $CODE$
+  SELECT count( v )
+  FROM generate_series( make_date( yy, 01, 01 ),
+                       make_date( yy, 12, 31 ),
+                       '1 days' ) v
+  WHERE
+     extract( dow from v ) NOT IN ( 0, 6 );
+  $CODE$
+  LANGUAGE sql;
-- 
cgit