How to write SQL Functions in PostgreSQL

How to write SQL Functions in PostgreSQL.

How would you feel if after watching this video, you were able to solve new types of problems?

If you've found this videos useful and wish to show your support with a small XLM donation, feel free to use the following values:

XLM address
GC23BCI644P66PPNRGRMKFFVQZZXE3CSCGMFIYFV5OW4WCPM2XICKWQZ

XLM Memo
502087138


Table of Contents
00:00 Begin Video
00:11 How to write postgresql string function MID, use $1
02:54 How to write sql function that uses ALIAS keyword
04:51 How to write sql function that uses parameter names and datatypes
05:51 - Use a template for fnMakeFull (firstname + secondName), how to use IF ELSIF ELSE, concat, concat_ws, initcap
11:51 how to use INOUT parameter, write function to swap
13:05 how to write function that uses array as input parameter
how to loop over array to calculate the mean value
16:27 to write sql function that returns data from a table QUERY RESULT, return query
20:42 End message from scott johnson




how to create function in postgresql using pgadmin
create or replace function postgres
postgresql function with parameters
postgresql function return table all columns
postgres return dataset from function
postgresql alias column
postgresql column alias where clause
postgres string concat operator

#softwareNuggets, #postgresql, language plpgsql, @SoftwareNuggets