Re: [sqlite] Group by in sqlite 3.8 works a little differently depending on the spaces at the end

2013-08-28 Thread Max Vlasov
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

Re: [sqlite] Group by in sqlite 3.8 works a little differently depending on the spaces at the end

2013-08-28 Thread Igor Tandetnik
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 (

Re: [sqlite] Group by in sqlite 3.8 works a little differently depending on the spaces at the end

2013-08-28 Thread John McKown
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

Re: [sqlite] GROUP BY in SQLite

2006-12-14 Thread jose isaias cabrera
Give each line a few extra spaces. I don't know why, but I had the same error. I gave a few extra spaces, specially at the end, and it worked just find... - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Thursday, December 14, 2006 7:15 AM Subject: [sqlite] GROUP BY in SQ

Re: [sqlite] GROUP BY in SQLite

2006-12-14 Thread Kees Nuyt
Hi Bart, First of all, you clearly try to start a new subject here, so please don't reply to something completely different, but start a new thread. TIA. On Thu, 14 Dec 2006 12:15:57 - (GMT), you wrote: >Just wondering about the implementation of GROUP BY in SQLite. >It looks I can do: > >