PostgreSQL Snippets


Topic Replies Views Activity
About the PostgreSQL Snippets category
0 67 July 16, 2021
Removing Duplicate Rows
clean-data
3 327 August 11, 2021
Filter for last X days
date-time
0 294 July 26, 2021
Formatting Dates and Times
date-time
0 133 July 26, 2021
Histogram Bins
charts ,  analysis
0 194 July 20, 2021
Split Column to Rows
0 248 July 19, 2021
Regex: Validate Email Addresses
regex
0 119 July 20, 2021
Create Equal Sized Buckets
window-functions
0 94 July 20, 2021
Moving Average
analysis ,  window-functions
0 133 July 20, 2021
Generate Series of Dates and or Times
generating-data ,  date-time
0 77 July 20, 2021
Convert Epoch to Timestamp
0 80 July 19, 2021
Parse URL
regex
0 104 July 20, 2021
Median
analysis ,  window-functions
0 85 July 20, 2021
Cumulative Distribution Function
0 82 July 20, 2021
Replace NULL values
clean-data
0 114 July 16, 2021
Replace empty strings with NULLs
clean-data
0 318 July 16, 2021
Extract value from JSON String
json
0 125 July 16, 2021
Get last array element
arrays
0 79 July 16, 2021
Count NULL Values
clean-data
0 92 July 16, 2021
Reverse an array
arrays
0 148 July 16, 2021