Re: Tigger - Mailing list pgsql-sql

From Bricklen Anderson
Subject Re: Tigger
Date
Msg-id 42E14A76.9050805@PresiNET.com
Whole thread Raw
In response to Re: Tigger  (Jaime Casanova <systemguards@gmail.com>)
List pgsql-sql
Jaime Casanova wrote:
> This seems bad to me also:
> 
>>>CREATE FUNCTION session_update() RETURNS trigger AS $session_update$
>>>[..function body..]
>>>$session_update$ LANGUAGE plpgsql;
> 
> 
> I think it should be:
> CREATE FUNCTION session_update() RETURNS trigger AS $$
> [..function body..]
> $$ LANGUAGE plpgsql;
> 

No, the identifier between the $$ is legit, providing you're at v8 and above.


-- 
_______________________________

This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________


pgsql-sql by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: Tigger
Next
From: "David Hofmann"
Date:
Subject: Re: Tigger