Re: [sqlite] sqlite core function question

2007-02-02 Thread T
Hi Jay, or better yet, I expected this to work, using the modulo operator %: SELECT x - x % 1; Isn't that evaluated left to right? x-x = 0 0 %1 = 0 I don't think so. Well, yes, it is generally evaluated left to right, but mod has precedence of minus, so it gets evaluated first. So even

Re: [sqlite] sqlite core function question

2007-02-02 Thread Jay Sprenkle
On 1/31/07, T <[EMAIL PROTECTED]> wrote: or better yet, I expected this to work, using the modulo operator %: SELECT x - x % 1; Isn't that evaluated left to right? x-x = 0 0 %1 = 0 -- -- The PixAddixImage Collector suite: http://groups-beta.google.com/group/pixaddix SqliteImporter and

Re: [sqlite] sqlite core function question

2007-02-01 Thread Jeff Godfrey
From: "T" <[EMAIL PROTECTED]> Hi Jeff, I've encountered some functions that apparently aren't supported by SQLite So have I, such as replacing occurrences of an inner string. so I've created my own I've yet to figure out/try that. Is there a library somewhere of prebuilt functions we

Re: [sqlite] sqlite core function question

2007-01-31 Thread T
Hi Jeff, I've encountered some functions that apparently aren't supported by SQLite So have I, such as replacing occurrences of an inner string. so I've created my own I've yet to figure out/try that. Is there a library somewhere of prebuilt functions we can add? Is there and mechanism

Re: [sqlite] sqlite core function question

2007-01-31 Thread Jeff Godfrey
From: <[EMAIL PROTECTED]> I'm not sure what "int()" does. Maybe you are looking for round(). Or perhaps cast(expr AS int) will serve your needs. Sorry, I should have been clearer. INT just forces the result to be an integer. So, your "cast" example is probably what I need. Thanks for

Re: [sqlite] sqlite core function question

2007-01-31 Thread drh
"Jeff Godfrey" <[EMAIL PROTECTED]> wrote: > I'm currently converting some Access tables/views to SQLite. > I've encountered some functions that apparently aren't > supported by SQLite, so I've created my own (a power function > and an "IIF" function). Also, several of my queries have a > basic

[sqlite] sqlite core function question

2007-01-31 Thread Jeff Godfrey
I'm currently converting some Access tables/views to SQLite. I've encountered some functions that apparently aren't supported by SQLite, so I've created my own (a power function and an "IIF" function). Also, several of my queries have a basic int() wrapper, that also seems to be unsupported.