Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Docs warning: email unique #2457

Open
lalala0312 opened this issue Nov 12, 2024 · 1 comment
Open

Docs warning: email unique #2457

lalala0312 opened this issue Nov 12, 2024 · 1 comment

Comments

@lalala0312
Copy link

https://neon.tech/postgresql/postgresql-tutorial/postgresql-merge
In PostgreSQL MERGE statement examples
Image
if you set email unique, you can't insert like it
INSERT INTO leads(name, email) VALUES ('John Doe', '[[email protected]](../cdn-cgi/l/email-protection.html)'), ('Jane Doe', '[[email protected]](../cdn-cgi/l/email-protection.html)') RETURNING *;

Expected results:
Image

Actual result:
Image

@guidorice
Copy link

Happens in the previous section or two as well where email is UNIQUE.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants