Updated on 2025-06-07 GMT+08:00

U0530002: TaurusDB for PostgreSQL does not support variables in UPDATE

Description

Database Type and Version

  • Source database type and version: all SQL Server versions
  • Target database type and version: TaurusDB for PostgreSQL 16.4 and later

Syntax Example

TaurusDB for PostgreSQL does not support variables in the UPDATE statement.

SQL Server syntax:

UPDATE tab_1 SET @var = 'xxx';

Suggestion

Adjust related functions.