Hi,
the following query (notice the space at the end of the 3rd string)
Create table [TestTable] ([Title] TEXT);
INsert into TestTable (Title) VALUES ('simple text');
INsert into TestTable (Title) VALUES ('simple text');
INsert into TestTable (Title) VALUES ('simple text ');
select Trim(Title) a
FWIW, PostgreSQL 9.2.4 shows two rows, like sqlite 3.8.0.
On Wed, Aug 28, 2013 at 7:57 AM, Max Vlasov wrote:
> Hi,
>
> the following query (notice the space at the end of the 3rd string)
>
> Create table [TestTable] ([Title] TEXT);
> INsert into TestTable (Title) VALUES ('simple text');
> INse
On 8/28/2013 8:57 AM, Max Vlasov wrote:
the following query (notice the space at the end of the 3rd string)
Create table [TestTable] ([Title] TEXT);
INsert into TestTable (Title) VALUES ('simple text');
INsert into TestTable (Title) VALUES ('simple text');
INsert into TestTable (Title) VALUES (
On Wed, Aug 28, 2013 at 5:11 PM, Igor Tandetnik wrote:
> On 8/28/2013 8:57 AM, Max Vlasov wrote:
> See the recent discussion at
>
> http://comments.gmane.org/gmane.comp.db.sqlite.general/83005
>
> It's not about trailing spaces, but about whether Title in GROUP BY resolves
> to mean the table colu
4 matches
Mail list logo