Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Disjoint Sets

3 posts in Product Futures Discussion Last posting was on 2003-03-19 21:53:59.0Z
putnamr Posted on 2003-03-19 18:36:44.0Z
From: putnamr@river.it.gvsu.edu
Date: Wed, 19 Mar 2003 13:36:44 -0500
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Disjoint Sets
Message-ID: <FB701A7390E0025B00663DB585256CEE.00663DC385256CEE@webforums>
Lines: 16
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1024
Article PK: 95264

Hello,

When will ASE support getting DISJOINT datasets using say a "DISJOINT"
operand?

For example)
Assume A BAG(1,2,3,4) and B BAG(3,4,5,6)

SELECT *
FROM A

DISJOINT

SELECT *
FROM B
--------------------
RESULTANT BAG(1,2,5,6)


species8472 Posted on 2003-03-19 20:27:24.0Z
From: "species8472" <species8427@GEENZULT.thedominion.cc>
References: <FB701A7390E0025B00663DB585256CEE.00663DC385256CEE@webforums>
Subject: Re: Disjoint Sets
Date: Wed, 19 Mar 2003 21:27:24 +0100
Lines: 37
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <oe0nk-u0b.ln1@section31.thedominion.cc>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 3eea4713.cable.wanadoo.nl 62.234.71.19
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com!section31.thedominion.cc!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1027
Article PK: 95266

select * from a where not exists (select 'x' from b where a.key=b.key)
union
select * from b where not exists (select 'x' from a where a.key=b.key)

--
Joop

"Justice instead of revenge
Fight terrorism by removing its causes
Solidarity with all victims of the spiral of violence
Don't make new enemy stereotypes"

Senior Consultant Sybase Professional Services
http://thedominion.cc/

<putnamr@river.it.gvsu.edu> wrote in message
news:FB701A7390E0025B00663DB585256CEE.00663DC385256CEE@webforums...
>
> Hello,
>
> When will ASE support getting DISJOINT datasets using say a "DISJOINT"
> operand?
>
> For example)
> Assume A BAG(1,2,3,4) and B BAG(3,4,5,6)
>
> SELECT *
> FROM A
>
> DISJOINT
>
> SELECT *
> FROM B
> --------------------
> RESULTANT BAG(1,2,5,6)


putnamr Posted on 2003-03-19 21:53:59.0Z
From: putnamr@river.it.gvsu.edu
Date: Wed, 19 Mar 2003 16:53:59 -0500
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: Disjoint Sets
Message-ID: <95021ABC5BC5E15800784C4A85256CEE.0074FDC685256CEE@webforums>
References: <FB701A7390E0025B00663DB585256CEE.00663DC385256CEE@webforums> <oe0nk-u0b.ln1@section31.thedominion.cc>
Lines: 12
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1028
Article PK: 95267

Hello,

I am aware that this can be done through many different means. It is
unecessary coding that I don't feel is necessary. It is ugly. I may want
to union a set union another set and then union all another set and then
finally disjoint it. Gets even uglier very quickly.

I would like the ability to specify DISJOINT, DISJOINT LEFT, DISJOINT
RIGHT. My question is whether Sybase is delving into these depths or not.

Thanks,
Ryan Putnam