help with TCL function

From: "Jules Alberts" <jules(dot)alberts(at)arbodienst-limburg(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: help with TCL function
Date: 2003-09-10 13:27:06
Message-ID: 20030910132753.B5B7F1CB1D8@koshin.dsl.systemec.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-09-10 13:41:03 Re: RE : How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?
Previous Message Frank van Vugt 2003-09-10 13:24:59 plpgsql doesn't coerce boolean expressions to boolean