Re: how do i avoid multiple sessions from inserting the

> Why not something like that ?
[...]
> 2) IF NULL -> INSERT INTO users values (....'blah' ) WHERE NOT EXISTS
....
> -> SELECT id FROM users WHERE email = 'blah'

I tried, but it's giving me an error, as if INSERT wouldn't like the WHERE:

INSERT INTO users (email) VALUES ('john(at)doe(dot)com')
WHERE NOT EXISTS
(SELECT id FROM users WHERE email='john(at)doe(dot)com');

ERROR: parser: parse error at or near "WHERE"

(Btw, i didnt know that INSERT would accept a WHERE clause)