From: Todd Benson <caduceass@...>
Date: 2008-05-26T04:32:18+09:00
Subject: Re: Yup, it's call SQLite! :-)) Re: Is there a One True Postgresinterface? Is Ruby-postgresmaintained?

On Sun, May 25, 2008 at 2:17 PM, Bill Kelly <billk@cts.com> wrote:

> What actually happened there?  Is it that SQLite added the space
> on purpose because it noticed "garlic" didn't satisfy the
> "references measurements (measurement)" clause?

I don't think so, because, even though I could repeat it, I could add
another row, and then it would output correctly.

>
> Or is the space just some artifact of its output formatting that
> doesn't relate to the data?

Maybe that.  I'll play around a little.  I seem to remember SQLite
documentation claiming the software would comply with SQL standards up
to a point, but to play well with others decided to silently ignore
certain things that it wasn't capable of.

Todd