Re: Concat'ing columns

[Thimble Smith]

At 12:35, 19990805, jordanh@stripped wrote:
>SELECT COUNT(DISTINCT name) FROM tmp_names;
>
>	The manual seems to say that this should work, is this a 3.23 only
>feature?

Yes, it didn't work until 3.23.2.  The workaround is something like:

    SELECT name FROM tmp_names GROUP BY name;

    // now, count how many rows were returned - that is your answer

Tim