Changes between Version 67 and Version 68 of AdvancedApplicationDevelopment

Timestamp:

08/31/24 02:23:50 (4 weeks ago)

Author:

184006

Comment:

--

AdvancedApplicationDevelopment

@@ -160 +160 @@
 EXECUTE FUNCTION format_city_name();
 }}}
+\\ При внес на pets_name во полето Pets секоја прва буква  се претвара во голема буква.
+{{{}
+CREATE OR REPLACE FUNCTION format_pets_name()
+RETURNS TRIGGER AS $$
+BEGIN
+    NEW.name := initcap(lower(NEW.name));
+    RETURN NEW;
+END;
+$$ LANGUAGE plpgsql;
+
+
+CREATE TRIGGER trigger_format_pets_name
+BEFORE INSERT OR UPDATE ON pets
+FOR EACH ROW
+EXECUTE FUNCTION format_pets_name();
+
+}}}