Task 1 done in PostgreSQL

1 files changed, 12 insertions, 0 deletions

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;