[GENERAL] COUNT() with ORDER BY

create temp table test (col char); select count(col) from test order by col; causes ERROR: column test.col must appear in the GROUP BY clause or be used in an aggregate function SQL state: 42803 How to fix this ? This statement is generated by DbLinq driver and it is difficult to re-qrite

Re: [GENERAL] COUNT() with ORDER BY

On Mon, Jan 14, 2008 at 09:02:46PM +0200, Andrus wrote: create temp table test (col char); select count(col) from test order by col; causes ERROR: column test.col must appear in the GROUP BY clause or be used in an aggregate function SQL state: 42803 How to fix this ? This

Re: [GENERAL] COUNT() with ORDER BY

On 14 jan, 17:02, Andrus [EMAIL PROTECTED] wrote: create temp table test (col char); select count(col) from test order by col; causes ERROR: column test.col must appear in the GROUP BY clause or be used in an aggregate function SQL state: 42803 How to fix this ? This statement is

Re: [GENERAL] COUNT() with ORDER BY

fervent with love. Princes abandoned their pomp; maidens suffered martyrdom. Whence came this influence? The Messiah was come. These were the effect and sign of His coming. 773. Destruction of the Jews and heathen by Jesus Christ: Omnes gentes venient et adorabunt eum.156 Parum est ut,157 etc.