Re: SQL Challenge: Arbitrary Cross-tab - Mailing list pgsql-sql

Greg Sabino Mullane wrote:

> 
> Names shortened to spare the line lengths:
> 
> SELECT bob.cid,
>   (SELECT tid FROM ats WHERE cid=bob.cid LIMIT 1) AS tk1,
>   (SELECT tid FROM ats WHERE cid=bob.cid LIMIT 1 OFFSET 1) AS tk2,
>   (SELECT tid FROM ats WHERE cid=bob.cid LIMIT 1 OFFSET 2) AS tk3,
>   (SELECT tid FROM ats WHERE cid=bob.cid LIMIT 1 OFFSET 3) AS tk4,
>   (SELECT tid FROM ats WHERE cid=bob.cid LIMIT 1 OFFSET 4) AS tk5,
>   (SELECT tid FROM ats WHERE cid=bob.cid LIMIT 1 OFFSET 5) AS tk6,
>   (SELECT tid FROM ats WHERE cid=bob.cid LIMIT 1 OFFSET 6) AS tk7,
>   (SELECT tid FROM ats WHERE cid=bob.cid LIMIT 1 OFFSET 7) AS tk8,
> FROM (SELECT DISTINCT cid FROM ats) AS bob;
> 

Don't you miss for each subselect an order by tid ?


Regards
Gaetano Mendola