Advanced Customer Segmentation with Hierarchical Clustering in SQL

Design a PostgreSQL query that performs hierarchical customer segmentation using advanced window functions and k-means clustering logic. The analysis should incorporate multiple dimensions including total spend, transaction frequency, recency, and customer lifetime value. Create a solution that generates distinct customer segments with clear boundary conditions, and provide a method to dynamically update segment classifications as new transactional data arrives.