Re: help with TCL function

Поиск
Список
Период
Сортировка
От Jules Alberts
Тема Re: help with TCL function
Дата
Msg-id 20030910141621.909241CB1D8@koshin.dsl.systemec.nl
обсуждение исходный текст
Ответ на help with TCL function  ("Jules Alberts" <jules.alberts@arbodienst-limburg.nl>)
Список pgsql-general
Op 10 Sep 2003 (15:27), schreef Jules Alberts <jules.alberts@arbodienst-limburg.nl>:
> Hello everybody,
>
> Someone helped me earlier with this TCL trigger function:
>
> create or replace function tlow() returns trigger as '
>   set NEW($1) [string tolower $NEW($1)]
>   return [array get NEW]'
> language 'pltcl';
>
> I use it to force lowercase of values inserted in the db. There is one
> problem though, if the parameter is absent, the function will give an
> error message. I would like it to rather check for null before tolower
> is applicated. In semicode:
>
> if ($1 <> NULL) {
>  set NEW($1) [string tolower $NEW($1)]
> }
> return [array get NEW]'
>
> but I have no idea how to do this in TCL. Can somebody please tell me?
> Thanks a lot!

I found argisnull, but I can't run it, apparently it cannot be used in
triggers :-( Does anybody know a solutions for this problem? Thanks!

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Constructing column from different individual fields in
Следующее
От: Kaare Rasmussen
Дата:
Сообщение: 7.4 defaulting to ipv6 ?