Re: [sqlite] Is it possible to check a data type in a query?

2011-07-15 Thread Amit Chaudhuri
Perfect - thank you both.. On Thu, Jul 14, 2011 at 12:15 PM, Simon Slavin wrote: > > On 13 Jul 2011, at 1:13pm, Amit Chaudhuri wrote: > > > I have situation where a column may contain prices (REAL) or a string > > meaning "no price for this, sorry." I can handle this in

Re: [sqlite] Is it possible to check a data type in a query?

2011-07-14 Thread Simon Slavin
On 13 Jul 2011, at 1:13pm, Amit Chaudhuri wrote: > I have situation where a column may contain prices (REAL) or a string > meaning "no price for this, sorry." I can handle this in application code > but was wondering if I am overlooking a Sqlite feature which might do the > same out of the box:

Re: [sqlite] Is it possible to check a data type in a query?

2011-07-14 Thread Richard Hipp
On Wed, Jul 13, 2011 at 8:13 AM, Amit Chaudhuri wrote: > Hi all, > > I have situation where a column may contain prices (REAL) or a string > meaning "no price for this, sorry." I can handle this in application code > but was wondering if I am overlooking a Sqlite

[sqlite] Is it possible to check a data type in a query?

2011-07-14 Thread Amit Chaudhuri
Hi all, I have situation where a column may contain prices (REAL) or a string meaning "no price for this, sorry." I can handle this in application code but was wondering if I am overlooking a Sqlite feature which might do the same out of the box: perhaps a TYPE( ) or an IsText( ) function..? A