[sqlite] Does sqlite has isnull function?

Hi All, I don't think sqlite support isnull function, but I wonder is there other function has same functionality but different name? thanks, Ming

Re: [sqlite] Does sqlite has isnull function?

You may use operator ISNULL instead. For example SELECT x FROM table WHERE y ISNULL. Best reagrds, Witold - Original Message - From: [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Sunday, March 06, 2005 2:12 PM Subject: [sqlite] Does sqlite has isnull function? Hi All, I don't

Re: [sqlite] Does sqlite has isnull function?

Sometimes IFNULL function can be also enough (http://sqlite.org/lang_expr.html). - Original Message - From: Witold Czarnecki [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Sunday, March 06, 2005 2:21 PM Subject: Re: [sqlite] Does sqlite has isnull function? You may use operator

Re: [sqlite] Does sqlite has isnull function?

On Sun, 2005-03-06 at 09:12 -0400, [EMAIL PROTECTED] wrote: Hi All, I don't think sqlite support isnull function, but I wonder is there other function has same functionality but different name? thanks, Ming Is the function IS NULL? According to

Re: [sqlite] Does sqlite has isnull function?

Witold Czarnecki wrote: You may use operator ISNULL instead. For example SELECT x FROM table WHERE y ISNULL. Best reagrds, Witold - Original Message - From: [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Sunday, March 06, 2005 2:12 PM Subject: [sqlite] Does sqlite has isnull

Re: [sqlite] Does sqlite has isnull function?

[EMAIL PROTECTED] wrote: Witold Czarnecki wrote: You may use operator ISNULL instead. For example SELECT x FROM table WHERE y ISNULL. Best reagrds, Witold - Original Message - From: [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Sunday, March 06, 2005 2:12 PM Subject: [sqlite] Does

[sqlite] Bug from ticket 1141 breaks existing applications

Hello Dr. Hipp, Hello sqlite users, while trying to upgrade to sqlite 3.1.3, I've encountered the bug described in ticket #1141 (sqlite returns the primary key's column name, if any, instead of the ROWID column, in a query like SELECT rowid, * FROM table). Any idea how to fix this (if it's an

[sqlite] Interrupting write back of journal causes database corruption?

~Yodels, I wonder if the interruption of writing back the journal can lead to corruption of the database. I understand how corruption is prevented when writing to the journal, but not how corruption can be prevented if the journal is written back to the database. I could not find anything in

Re: [sqlite] Interrupting write back of journal causes database corruption?

On Sun, 2005-03-06 at 21:26 +0100, Joris wrote: I wonder if the interruption of writing back the journal can lead to corruption of the database. No. Interrupting a write to the journal or a journal rollback will not corrupt the database file. At least, not unless there are undiscovered bugs

Re: [sqlite] Bug from ticket 1141 breaks existing applications

George Ionescu wrote: while trying to upgrade to sqlite 3.1.3, I've encountered the bug described in ticket #1141 (sqlite returns the primary key's column name, if any, instead of the ROWID column, in a query like SELECT rowid, * FROM table). Any idea how to fix this (if it's an easy one),

[sqlite] pragma table_info

Is there anyway to do 'pragma table_info' on a table in an attached database (even if a table in the main database has the same name). I guess I am wondering why this doesn't work: PRAGMA table_info(database_name.table_name) I get 'near .: syntax error'. -Charlie