[TYPO3-dev] select distinct in TS

[Christian Welzel]

Ries van Twisk wrote:

> Group by is also supported by postgresql.. I think also ms sql support
> group by.

Thats right, postgres does support "group by" but not the way
mysql does.
in mysql you can "group by" by only ONE column but select many.
like this: 

SELECT * FROM table GROUP BY some_column;

and this query does not work in any db other than mysql.
And as i understood Helge, he suggested using such a query.

-- 
 MfG, Christian Welzel

  GPG-Key:     http://www.camlann.de/key.asc
  Fingerprint: 4F50 19BF 3346 36A6 CFA9 DBDC C268 6D24 70A1 AD15