CODEWITHSUNDEEP
sqlite
user34537
user34537

Reputation:

select from null?

I am writing a trigger and i need 2 tables. new/old which already exist and p for the parent. However p may be null so if i do a

select new.a, new.b, ifnull(p.name, new.c) from p

i'll get 0 results. if p is null. So how do i solve this? can i select from null or something else and left join p and use ifnull? i am not sure how to do this.

Upvotes: 0

Views: 240

Answers (2)

user34537
user34537

Reputation:

I ended up using a dummy table.

select ... from blah as dummy on dummy.id = new.id //rest of my sql

Upvotes: 0

shinkou
shinkou

Reputation: 5154

I'm not very familiar with sqlite, but maybe you can try something like this.

SELECT
    new.a, new.b, new.c AS newcol
FROM
    p
WHERE
    p.name = NULL
UNION
SELECT
    new.a, new.b, p.name AS newcol
FROM
    p
WHERE
    p.name <> NULL

Upvotes: 1

Related Questions