GroupBy SubString doesn't work

[LPCRoy]

This generates invalid SQL:

Code: Select all

dataContext.Table
     .GroupBy(x => x.StringValue.Substring(0, 1))
     .Select(x => new { StringText= x.Key, 
                                 Count = x.Count(y => y.SomeFlag == true) });

[AndreyR]

Thank you for the report. We have reproduced this problem too.
I will let you know when it's resolved.

[AndreyR]

This problem is also fixed, look forward to the upcoming build of dotConnect for PostgreSQL.