Tag Info

Hot answers tagged


You can easily find the subsequence when you cast the arrays to strings and replace the curly brackets with commas: translate(cast(sequence as varchar(10000)), '{}',',,') {1,3,17,25,377,424,242,1234} -> ',1,3,17,25,377,424,242,1234,' Do the same for the array you're searching for and add a leading and trailing %: '%' || translate(cast(searchedarray ...


I would handle this scenario by means of a (super)type-subtype relationship. You may find this answer of help as an introductory resource. If I understand your specifications well, the following assertions are relevant in your business context: A Party is either one Group or one User. A User can be member of one-to-many Groups or, put another way, a Group ...

Only top voted, non community-wiki answers of a minimum length are eligible