swap - установливает значение var на место any и возвращает предыдущее значение. +Swap - префиксный класс для +relations, где данные должны храниться в значении отдельного транзитного символа вместо объекта отношения. Обычно используется для данных, ...
How to Create Eye-Catching Weed T-Shirt Designs: A Guide for Print-on-Demand Entrepreneurs In the ever-evolving world of fashion, custom t-shirts have taken a center stage, especially in niche markets like cannabis culture. With the rising popularity...
Create Eye-Catching T-Shirts with Weed Quotes: A Guide to Unique Designs In the world of fashion, t-shirts have always been a canvas for self-expression. With the rise of personalized and niche styles, one theme that stands out is weed quotes. These ...
Data type conversion is vital in database management. PostgreSQL's CAST function simplifies this process. This article highlights how to use CAST for data type conversions effectively. Using CAST in PostgreSQL Here are key examples demonstrating the ...
replace를 이용하여 특정 문자를 다른 문자로 바꾸는 방법 REPLACE 함수는 컬럼 내의 특정 문자를 다른 문자로 바꿀 때 사용한다. replace(바꿀 컬럼, 현재 값, 바꿀 값) ex) '문곡리'라고 되어있는 주소를 '문가리'라고 바뀐 주소명으로 치환해주기 SELECT addr, REPLACE (addr, '문곡리', '문가리') "바뀐주소" FROM food_orders WHERE addr LIKE '%문곡리%' ...
Let’s explore the CAST PostgreSQL function, take a look at what it is, what it does, its pros and cons, and when to use it. Tools used in this tutorial DbVisualizer - top rated database management tool and SQL client. The PostgreSQL database. Cast...
![[sql study note] replace, substring, concat, if, case, cast](https://cdn.hashnode.com/res/hashnode/image/upload/v1709194867103/c4a38575-a31d-4c9a-95dd-179e54b322cd.png)
