Skip site navigation (1) Skip section navigation (2)

Subquery limits

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: hackers(at)postgreSQL(dot)org (PostgreSQL-development)
Subject: Subquery limits
Date: 1998-03-27 21:16:03
Message-ID: 199803272116.QAA20473@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Found this on the MySQL crashme page, http://www.tcx.se/crash-me.html:

                                                Join methods
                                     MySQL         EMPRESS       mSQL      Oracle   PostgreSQL    SOLID
 cross join (same as from
 a,b)                         [yes]              [no]        [no]        [no]       [no]      [yes]
 full outer join              [no]               [no]        [no]        [no]       [no]      [yes]
 tables in join               32                 63          +64         +64        30        23
 left outer join              [yes]              [no]        [no]        [no]       [no]      [yes]
 left outer join using        [yes]              [no]        [no]        [no]       [no]      [no]
 natural join                 [no]               [no]        [no]        [no]       [no]      [no]
 natural left outer join      [yes]              [no]        [no]        [no]       [no]      [no]
 left outer join odbc style   [yes]              [no]        [no]        [no]       [no]      [yes]
 recursive subqueries                            49                      +64        226       14
 ^^^^^^^^^^^^^^^^^^^^

 right outer join             [no]               [no]        [no]        [no]       [no]      [yes]
 ANSI SQL simple joins        [yes]              [yes]       [yes]                  [yes]     [yes]
 subqueries                   [no]               [yes]       [no]        [yes]      [yes]     [yes]
 ^^^^^^^^^^

So he did updated it to be accurate.  Interesting we support 226 levels
of recursive subqueries.  That sounds like a lot.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

pgsql-hackers by date

Next:From: ocieDate: 1998-03-27 21:23:55
Subject: Re: AW: AW: [HACKERS] Re: PostgreSQL reference manual
Previous:From: David GouldDate: 1998-03-27 20:15:19
Subject: Re: [HACKERS] Data type removal

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group