Re: SQL Challenge: Arbitrary Cross-tab

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>
Subject: Re: SQL Challenge: Arbitrary Cross-tab
Date: 2004-08-18 14:48:27
Message-ID: 41236C3B.4060801@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Greg Sabino Mullane wrote:

>
>
>>>Don't you miss for each subselect an order by tid ?
>
>
> No: since all the SELECTs are part of one statement, they
> will have the same (pseudo-random) implicit order.

Is this guaranted ?

Regards
Gaetano Mendola

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-08-18 15:13:35 Re: SQL Challenge: Arbitrary Cross-tab
Previous Message Stephan Szabo 2004-08-18 14:38:44 Re: multi column foreign key for implicitly unique columns