postgresql UPDATE 起别名出现更新错误

最新推荐文章于 2023-06-07 23:33:07 发布

liguangxian2018

最新推荐文章于 2023-06-07 23:33:07 发布

阅读量8.5k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： postgresql 文章标签： postgresql SQL UPDATE AS

本文链接：https://blog.youkuaiyun.com/liguangxianbin/article/details/85066579

UPDATE

环境： postgresql 10.5
redhat7.
上下文：

db1=# \d
               List of relations
 Schema |      Name      |   Type   |   Owner   
--------+----------------+----------+-----------
 public | stu_bk         | table    | wangyanru
 public | student        | table    | wangyanru
 public | student_bk     | table    | wangyanru
 public | student_id_seq | sequence | wangyanru
 public | subject        | table    | wangyanru
(5 rows)


db1=# \d+ student
                                                            Table "public.student"
  Column   |            Type             | Collation | Nullable |               Default               | Storage  | Stats target | Description 
-----------+-----------------------------+-----------+----------+-------------------------------------+----------+--------------+-------------
 id        | integer                     |           | not null | nextval('student_id_seq'::regclass) | pl