allow array relationships based on array type columns

[ravensnowbird]

It is possible to have array relationships to directly map to an array field in postgres without any middle table connection.

Conversations table

add_column :conversations, :user_ids, :uuid, array: true

[rikinsk]

@ravensnowbird Unfortunately I am not quite sure of the use case here. Can you maybe share some more details on what you are expecting and how it would be useful.

PS: Sorry for the delay in response. This seems to have been missed somehow.

[rikinsk]

Actually I think I get it now. You would like to have an array relationship to the users table via the user_ids array type column of conversation table.

[ravensnowbird]

@rikinsk Yes. Postgres by default supports array field of strings/integers. These can be used to form a relationship directly avoiding a middle table users_conversations.

[ghyath5]

@ravensnowbird

Did you find any work-around to do this kind of array relationship ?

[ravensnowbird]

Actually I think I get it now. You would like to have an array relationship to the users table via the user_ids array type column of conversation table.

Exactly. this is working with an array relationship. It didn't work in the old version. it works on the latest one. I guess it must have been some bug. Closing this now.

[pandoratoolbox]

This isn't working in Hasura v2.0.0-alpha.9, produces error: "error": { "exec_status": "FatalError", "hint": "No operator matches the given name and argument types. You might need to add explicit type casts.", "message": "operator does not exist: bigint[] = bigint", "status_code": "42883", "description": null },

[efstathiosntonas]

any news in this? ^^ many customers have this issue (many open issues). Yes, intermediate table is a solution but we want to avoid it.

[sounden]

Yepp looking for same functionallity.

[gherciu]

@rikinsk ^^

[kokroo]

Looking for the same!

EDIT:

I figured out a workaround using computed fields. I created a function in SQL to return rows based on some logic, and then I created a computed field that points to this function. Works beautifully!