Re: Triggers and Domains

Поиск
Список
Период
Сортировка
От ekekakos
Тема Re: Triggers and Domains
Дата
Msg-id 25214530.post@talk.nabble.com
обсуждение исходный текст
Ответ на Re: Triggers and Domains  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
So for every table I must create the 2 fields with the 2 triggers. Is there
any way to simplify this?
From what you are saying I think no. Am I right?

Thanks again
Elias


Tom Lane-2 wrote:
>
> ekekakos <ekekakos@hol.gr> writes:
>> And it does not work during the update.
>
> Oh, you mean you want the field to change during updates?  No, a
> DEFAULT won't do that for you.  You'll have to use a trigger.
>
>             regards, tom lane
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
>

--
View this message in context: http://www.nabble.com/Triggers-and-Domains-tp25209238p25214530.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Triggers and Domains
Следующее
От: Ruzsinszky Attila
Дата:
Сообщение: Date interval and bitmask for days - Pl/Perl or SQL