PostgreSQL and SQL:2023

Re:PostgreSQL and SQL:2023 by meotimdihia on Friday June 02, 2023 @12:04PM (#36166916)

Is there a database that supported arrays of foreign keys?

[ Parent | on HN ]

Re:PostgreSQL and SQL:2023 by lolive on Friday June 02, 2023 @03:28PM (#36169677)

We use it in Palantir, that is a proprietary overlay on top of Spark. It supports this feature reasonably fine.

[ Parent | on HN ]

Re:PostgreSQL and SQL:2023 by paulddraper on Friday June 02, 2023 @04:51PM (#36170581)

Of the major databases, only Oracle and PostgreSQL have array extensions and neither support FKs as array elements.

I'm curious how people think this feature should work? ON DELETE SET NULL, ON DELETE CASCADE, something else?

[ Parent | on HN ]

Re:PostgreSQL and SQL:2023 by evangow on Tuesday June 06, 2023 @04:18PM (#36218553)

I would love it if the would remove the key from the array.

[ Parent | on HN ]