Re: Tigger

From: Bricklen Anderson <BAnderson(at)PresiNET(dot)com>
To: Jaime Casanova <systemguards(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Tigger
Date: 2005-07-22 19:35:18
Message-ID: 42E14A76.9050805@PresiNET.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.
_______________________________

In response to

  • Re: Tigger at 2005-07-22 19:33:11 from Jaime Casanova

Browse pgsql-sql by date

  From Date Subject
Next Message David Hofmann 2005-07-22 19:56:33 Re: Tigger
Previous Message Jaime Casanova 2005-07-22 19:33:11 Re: Tigger