what is the difference

Posted by veilig on Stack Overflow See other posts from Stack Overflow or by veilig
Published on 2010-04-07T11:26:27Z Indexed on 2010/04/07 11:43 UTC
Read the original article Hit count: 434

Filed under:
|
|
|

I'm not even sure what this is called?

But I'm trying to learn what the difference is between writing a function like this is in plpgsql:

CREATE OR REPLACE FUNCTION foo() RETURNS TRIGGER AS $$
    ....
$$ LANGUAGE plpgsql;

vs

CREATE OR REPLACE FUNCTION foo() RETURNS TRIGGER AS $foo$
    ....
$foo$ LANGUAGE plpgsql;

is there a difference when using $$ vs $foo$? why would someone choose one over another? perhaps I've just missed some documentation explaining the difference. If someone could enlighten me, I'd really appreciate it.

© Stack Overflow or respective owner

Related posts about postgresql

Related posts about sql