-
[Postgresql] $$ 의미DB/PostgreSQL 2020. 8. 10. 14:25
CREATE OR REPLACE FUNCTION increment(i integer) RETURNS integer AS $$ BEGIN RETURN i + 1; END; $$ LANGUAGE plpgsql;
Dollar-Quoted String Constants
- 함수 정의의 시작과 끝을 알려주는 기호
** https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-DOLLAR-QUOTING
** https://stackoverflow.com/questions/31285366/what-does-the-mean-in-postgresql-function
'DB > PostgreSQL' 카테고리의 다른 글
[PostgreSQL] DataType - serial (0) 2023.01.05 [PostgreSQL] 프로시저 vs 함수 (0) 2020.08.13