Обсуждение: Conditional statements

Поиск
Список
Период
Сортировка

Conditional statements

От
"Mark Alliban"
Дата:
Hi,

I was wondering if it is possible to have conditional statements in
postgres?

For example:
IF NOT EXISTS(SELECT * FROM testtable WHERE id=3)
    INSERT INTO testtable (id) VALUES (3)

TIA,
Mark.