Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

I believe I am concating to my jsonb array wrong. if I have declare like `mylist jsonb := '[]';` and in loop want to push opjects into it 

```
mylist = mylist || jsonb_build_object(
      'id', my_id::uuid,
      'myfield', some_text,
    );

```
I think this is actually making the list like jsonb[] type without string around '[]' its like []. Error is `operator does not exist: character varying = jsonb` for overall func and I think something like this is issue

Hello <@400305576992833536>!
This thread has been automatically created from your message in <#843999948717555735> a few seconds ago.

We have already mentioned the <@&951828363943759883> so that they can see your message and help you as soon as possible!

**Want to unsubscribe from this thread?**
Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates.

**Want to change the title?**
Use the ``/title`` command!

**We have solved your problem?**
Click the button below to archive it.

idk what i ended up doing maybe changed from jsonb_extract_path to myjson->>'something' type syntax idk what the issue was or what was the thing that fixed but ill just close this

Thread was archived by <@400305576992833536>. Anyone can send a message to unarchive it.