Title Case Transformation with Hyphen Sensitivity
You are given a table
user_content with a column content_text. Your task is to generate a report that transforms the text into Title Case based on specific business rules. The first letter of every word must be capitalized, and all subsequent letters in that word must be lowercase. The transformation must recognize a hyphen (-) as a word boundary, meaning segments on both sides of a hyphen (e.g., 'high-speed') must be capitalized ('High-Speed'). All original spacing, including multiple consecutive spaces, must be preserved exactly as they appear in the source data. Return the original content_id, content_text, and the newly transformed_text column.PostgreSQLINITCAPPostgreSQL
00