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

Re: SQL Challenge: Arbitrary Cross-tab

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL Challenge: Arbitrary Cross-tab
Date: 2004-08-18 11:47:41
Message-ID: 4229381dfaf8f3ae1e4cb0ae62d6f012@biglumber.com (view raw or flat)
Thread:
Lists: pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 
 
> 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. Since
Josh's requirement said the order of the tids* was not important,
I can be lazy and get away with it in this case. An order by
would not hurt, of course.
 
* As far as PG goes, this is not an ideal abbreviation! :)
- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200408180745
-----BEGIN PGP SIGNATURE-----
 
iD8DBQFBI0InvJuQZxSWSsgRApW7AKCpFN6TMQ3WjcJgZse5f+Ap6/Y7RACfSSlc
MZusqEadF2xZrE4PLOhmMek=
=pnQz
-----END PGP SIGNATURE-----



In response to

Responses

pgsql-sql by date

Next:From: Jan WieckDate: 2004-08-18 13:33:04
Subject: Re: multi column foreign key for implicitly unique columns
Previous:From: Gaetano MendolaDate: 2004-08-18 11:01:24
Subject: Re: SQL Challenge: Arbitrary Cross-tab

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