Unix Technical Forum

Re: union subqueries in "from" clause (IDS 9.4)

This is a discussion on Re: union subqueries in "from" clause (IDS 9.4) within the Informix forums, part of the Database Server Software category; --> It's a little confusing on principle but when usaed properly you could some very interseting things. The only down ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 09:19 AM
Jean Sagi
 
Posts: n/a
Default Re: union subqueries in "from" clause (IDS 9.4)


It's a little confusing on principle but when usaed properly you could
some very interseting things.

The only down I've seen on this multiset construct is that it isn'y able
to handle first.


J.

Dan escribió:
> Thanks again to everyone who suggested the Table-Multiset solution to this
> problem. It's something I don't think I'd ever have figured out on my own.
> And, after spending some time reading the docs on multisets & virtual tables
> & collection subqueries & collection-derived tables, I still find it a bit
> confusing... For my purposes (selecting from the results of a subquery), it
> seems like quite a lot of semantic structure for something that's otherwise
> fairly simple. But it works, which is the important part. And maybe after
> another read or two it will make more sense.
>
>
>

sending to informix-list
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 11:11 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com