Re: getting trigger to work - Mailing list pgsql-general

Merrill Oveson wrote:

>This function & trigger don't work:
>
>create function prosp_tf_bi() returns opaque as '
>      begin
>                if new.pros_id is null then
>                     new.pros_id:= A1000;
>                end if;
>        return new;
>        end; ' language 'plpgsql';
>
>
>The error is "Attribute 'a1000' not found"
>
>The column pros_id is char(5).
>How do I put in the  'A1000'?
>
Hi,

You need to surround the new value with two pairs of quotation marks,
like this:

''A1000''

Regards,

Antonio Sergio