Re: how do i avoid multiple sessions from inserting the - Mailing list pgsql-general

> 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@doe.com')
        WHERE NOT EXISTS
                (SELECT id FROM users WHERE email='john@doe.com');

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

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