List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:August 5 1999 6:16pm
Subject:Re: Concat'ing columns
View as plain text  
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
Thread
Concat'ing columnsjordanh5 Aug
  • Re: Concat'ing columnsSteve Ruby5 Aug
    • Re: Concat'ing columnsjordanh5 Aug
      • Re: Concat'ing columnsThimble Smith5 Aug
        • Re: Concat'ing columnsjordanh5 Aug
          • Re: Concat'ing columnsThimble Smith5 Aug