By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,809 Members | 1,997 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,809 IT Pros & Developers. It's quick & easy.

Derived tables?

P: n/a
CSN
Just wondering - does PG support derived tables? I'm
not really sure what the difference is between them
and subqueries.

http://www.mysql.com/news-and-events...e_2004_32.html
http://www.sqlservercentral.com/colu...intversion.asp

__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
CSN <co*******************@yahoo.com> writes:
Just wondering - does PG support derived tables? I'm
not really sure what the difference is between them
and subqueries.


None whatever, at least using the definition offered by your second
reference:

A derived table is a select statement inside parenthesis, with
an alias, used as a table in a join.

The SQL92 spec appears to use the phrase in exactly this way (except
they don't require the construct to appear in a join, as indeed we don't
either; the most correct explanation would probably be "used as a table
in a FROM clause").

MySQL often has their own spin on such terms ;-). I'm not sure what
MySQL 4.1 actually supports in this line. But I'll make a side bet that
they don't yet optimize them as well as we do ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.