Richard Hipp wrote on Monday, September 15, 2014 3:16 PM
> On Mon, Sep 15, 2014 at 3:02 PM, Nelson, Erik - 2 <
> erik.l.nel...@bankofamerica.com> wrote:
>
> > When I query a field defined with type 'real', I get '.0' appended to
> > the results for whole numbers. For example if the value in the field
> > is 1, it appears as 1.0 in the query results.
> >
> > Is there some way for me to change this?
> >
>
> Instead of "SELECT x FROM..." you could enter "SELECT printf('%g',x)
> FROM ...".
Yes, understood. I was hoping to affect the default behavior and don't mind
maintaining the patch.
----------------------------------------------------------------------
This message, and any attachments, is for the intended recipient(s) only, may
contain information that is privileged, confidential and/or proprietary and
subject to important terms and conditions available at
http://www.bankofamerica.com/emaildisclaimer. If you are not the intended
recipient, please delete this message.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
