| 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: | Whole Thread | Raw Message | 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!
| 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 |