#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2016
    Posts
    2
    Rep Power
    0

    Question: Multisets


    Hello! I have an assignment from my university to write about about multisets,operations on multisets etc. in Firebird.My question is: Does Firebird even SUPPORT multisets,I have been looking for info on the subject all day and have found ZERO information concerning multisets in Firebird.Thank you in advance for any information you can provide on the subject.Have a good day.
  2. #2
  3. Lord of the Dance
    Devshed Specialist (4000 - 4499 posts)

    Join Date
    Oct 2003
    Posts
    4,131
    Rep Power
    2011
    If you look at their documentation:
    Firebird: SQL Conformance

    you will see multiset is not supported.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2016
    Posts
    2
    Rep Power
    0
    Originally Posted by MrFujin
    If you look at their documentation:
    Firebird: SQL Conformance

    you will see multiset is not supported.
    Thank you for the answer i DID look at their documentation and I DID see that I also found a 1000 page book on FIrebird
    that didnt have 1 word on multisets but I am going to have to prove this to my teacher so I just wanted to be ABSOLUTELY sure.Thank you again!
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2006
    Location
    Plovdiv. Bulgaria
    Posts
    242
    Rep Power
    17
    The IN operator works with sets. Even with sets returned from a query .... IN (SELECT TABLE1.FIELD_X FROM TABLE1) The result of the query may have multiple repeating values.
    In Firebird this is valid: SELECT FROM TABLE1.* WHERE TABLE1.FIELD_X IN (1,1,1,2,3,4,4,2)
    But maybe this is not the multiset you are looking for.
    Last edited by mIRCata; June 14th, 2016 at 03:58 AM.

IMN logo majestic logo threadwatch logo seochat tools logo