Timeline for Foreign Key - from same table and parent table
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 13, 2022 at 12:08 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 | typo |
| Oct 13, 2022 at 10:36 | vote | accept | Vidar | ||
| Aug 22, 2022 at 16:44 | comment | added | Erwin Brandstetter | @Vidar: numnulls() simply counts the number of NULL values in the input. It's a VARIADIC function taking up to 100 arguments. It's all in the linked answer. | |
| Aug 22, 2022 at 14:51 | comment | added | Vidar | Is the NumNulls just checking there can only be one out of the two columns with a NULL value? | |
| Aug 22, 2022 at 14:19 | comment | added | Vidar | Thanks for your time in putting together such a comprehensive answer. I think ultimately my table design is wrong, so I may have to change it so I have proper referential integrity. | |
| Aug 18, 2022 at 22:57 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 | added 143 characters in body |
| Aug 18, 2022 at 22:52 | history | answered | Erwin Brandstetter | CC BY-SA 4.0 |