Breaking News: Grepper is joining You.com. Read the official announcement!

psycopg2.errors.AmbiguousColumn: column reference "" is ambiguous

bilalahmed_dev answered on October 17, 2022 Popularity 6/10 Helpfulness 1/10

answer psycopg2.errors.AmbiguousColumn: column reference "" is ambiguous

psycopg2.errors.AmbiguousColumn: column reference "" is ambiguous

Comment

INSERT INTO video_editor_hashtag(hashtag)
VALUES ('xyzbca')
ON CONFLICT (hashtag) DO UPDATE SET count_hashtag = (SELECT count_hashtag FROM video_editor_hashtag where hashtag = 'xyzbca')  + 1;

# this is method to solve this in line no 3
(SELECT count_hashtag FROM video_editor_hashtag where hashtag = 'xyzbca')

Popularity 6/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: ambiguous reference sql

Link to this answer
Share Copy Link