RE: trouble with triggers

On Tue, 17 Jul 2001, Robert Treat wrote:

> Does the function have to be written using the plpgsql language? I tried
> writing my own function using just sql and it gave the same error message. I
> did trying writing the function using pgplsql:
>
> CREATE FUNCTION formatmyname() RETURNS opaque AS '
> BEGIN
> new.name := lower(new.name);
> RETURN NEW;
> END;
> ' LANGAUGE 'pgplsql';
>
> but got back a message that pgplsql was an unrecognized langauge, so I'm
> looking for a non pgplsql solution. If I'm spinning my wheels I will work on
> getting pgplsql working, but I'm hopeing to do it with a simpler approach.

There is no 'pgplsql' language, only 'plpgsql'. Functions in sql have LANGUAGE 'sql'.

cheers,
thalis

>
> robert
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>