How to restrict

Поиск
Список
Период
Сортировка
От Campbell, Lance
Тема How to restrict
Дата
Msg-id 6C004315-7728-4909-BCCD-2DE8F5DA3920@illinois.edu
обсуждение исходный текст
Ответы Re: How to restrict  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Re: How to restrict  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-admin

PostgreSQL 10.x

 

What is the best way to restrict the values on a text field to make sure they only contain particular values:  Example:  The field “type” can only contain the values of “X”, “Y” and “Z”.  Would a trigger be the best strategy?  Or is there a special SQL type I should use in this particular case? 

 

Thanks,

 

LANCE CAMPBELL

Software Architect

 

Web Services

Public Affairs

Contact the Webtools Team

217.333.0382

lance@illinois.edu

 

 

/var/folders/wp/1f6l7hw95y718z976kgnl5f9kr5rtc/T/com.microsoft.Outlook/WebArchiveCopyPasteTempFiles/signature_logo.png

 

Under the Illinois Freedom of Information Act any written communication to or from university employees regarding university business is a public record and may be subject to public disclosure.

 

Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tomáš Uko
Дата:
Сообщение: RE: streaming vs wal shipping issue
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: How to restrict