help with TCL function
От
Jules Alberts
Тема
help with TCL function
Дата
Msg-id
20030910132753.B5B7F1CB1D8@koshin.dsl.systemec.nl
Список
Дерево обсуждения
Re: help with TCL function ljb <lbayuk@mindspring.com>
Re: help with TCL function "Jules Alberts" <jules.alberts@arbodienst-limburg.nl>
Re: help with TCL function Rolf Jentsch <RJentsch@electronicpartner.de>
Re: help with TCL function darren@crystalballinc.com
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!
В списке pgsql-general по дате отправления
От: Tom Lane
Дата: