Hello everyone,

I hope you're all doing well! I have a question and I was wondering if anyone here could help me out. I'm encountering an issue while working with PostgreSQL on Railway and I’d appreciate any insights or suggestions.

The issue is that I’m trying to use COALESCE with TEXT and TEXT[] (array of text) in my database, but I keep getting the error COALESCE types text and text[] cannot be matched. This is preventing me from appending a new message to a TEXT[] column.

What I’ve tried so far:

• Converting the TEXT message to TEXT[] using ARRAY[$2]::TEXT[].

• Using COALESCE(context.chatcontext, ARRAY[]::TEXT[]) to handle NULL values.

• Verified that chatcontext is of type TEXT[] in the database.
  But I’m still encountering the same error.

If anyone has any advice or has faced a similar issue, I would greatly appreciate your help! Thank you so much in advance! 🙏