This is the idea david:
Why in the constant string we use the tag and we do not use the tag in the BODY?
In other wrods, why we write it $BODY$ and does not write it as $q$BODY$q$ or as $$BODY$$?
Also why in the single-quote syntax, each backslash will be written as four backslashes? While this will not be needed
inthe dolar-quoted string?
Regards
Bilal
--- On Sun, 8/30/09, David Fetter <david@fetter.org> wrote:
> From: David Fetter <david@fetter.org>
> Subject: Re: [GENERAL] $Body$
> To: "bilal ghayyad" <bilmar_gh@yahoo.com>
> Cc: pgsql-general@postgresql.org
> Date: Sunday, August 30, 2009, 6:44 PM
> On Sun, Aug 30, 2009 at 03:37:56PM
> -0700, bilal ghayyad wrote:
> > Hi List;
> >
> > What does it mean the $BODY$ when writing the
> function? In other
> > words: why to use the $ sign?
>
> See
> http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-DOLLAR-QUOTING
>
> Cheers,
> David.
> --
> David Fetter <david@fetter.org>
> http://fetter.org/
> Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!:
> dfetter
> Skype: davidfetter XMPP: david.fetter@gmail.com
>
> Remember to vote!
> Consider donating to Postgres: http://www.postgresql.org/about/donate
>