Op 11 Sep 2003 (0:45), schreef ljb <[EMAIL PROTECTED]>:
> I think you're missing something. When you use a Tcl function as a
> trigger, any arguments (like $1) are explicitly supplied in the CREATE
> TRIGGER command. You either define the trigger to call the function with
> a constant argument or
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 th
Op 26 Aug 2003 (12:38), schreef Robert Treat <[EMAIL PROTECTED]>:
> On Tue, 2003-08-26 at 07:28, Jules Alberts wrote:
> > Hello everyone,
> >
> > I'm working on a tiny trigger function that needs to ensure that all
> > values entered in a field are lowercase
Op 19 Aug 2003 (15:35), schreef The Hermit Hacker <[EMAIL PROTECTED]>:
> On Tue, 19 Aug 2003, Jules Alberts wrote:
>
> > Hello everyone,
> >
> > This is not a troll and I certainly don't want to start a holy war but
> > wouldn't it be a good idea to
Hello everyone,
Several columns in sereval tables in my DB should always be lowercase.
I now have a simple function:
create or replace function code_lower() returns trigger as '
begin
NEW.code := lower(NEW.code);
return NEW;
end'
language 'plpgsql';
which I call with a trigger l
