psql插入是否其他

发布于 2025-01-31 02:29:32 字数 573 浏览 3 评论 0原文

我想做到这一点，以便创建用户时，第一个用户在钱包上收到$ 1000，其余的 - $ 10（user_id -pk）

我提出了此请求

INSERT INTO users (user_id, login, balance, encrypted_password) 
select 1, 'login',
case
        when user_id = 1 then (login = 'login', balance= 1000, encrypted_password = 'password')
        else (login = 'login', balance = 10, encrypted_password = 'password')
end as user_id
RETURNING user_id

，但是当我提出此请求时，我会得到错误：错误：

错误：错误：列“ User_id”不存在第4行：@user_id == 0时（登录='login'，balance ='... ^ 提示：“用户”表中有一个“ user_id”列，但是从查询的这一部分无法引用它。

SQL状态：42703 角色：103

原文

I want to make it so that when creating a user, the first user receives $ 1000 on the wallet, and the rest - $ 10 (user_id - pk)

I made this request

INSERT INTO users (user_id, login, balance, encrypted_password) 
select 1, 'login',
case
        when user_id = 1 then (login = 'login', balance= 1000, encrypted_password = 'password')
        else (login = 'login', balance = 10, encrypted_password = 'password')
end as user_id
RETURNING user_id

but when I make this request, I get the error:

ERROR: ERROR: column "user_id" does not exist
LINE 4: when @user_id == 0 then (login = 'login', balance= '...
^
HINT: There is a "user_id" column in the "users" table, but it cannot be referenced from this part of the query.

SQL state: 42703
character: 103

分享到QQ

分享到微博