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 in the dolar-quoted string? Regards Bilal --- On Sun, 8/30/09, David Fetter <[email protected]> wrote: > From: David Fetter <[email protected]> > Subject: Re: [GENERAL] $Body$ > To: "bilal ghayyad" <[email protected]> > Cc: [email protected] > 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 <[email protected]> > http://fetter.org/ > Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: > dfetter > Skype: davidfetter XMPP: [email protected] > > Remember to vote! > Consider donating to Postgres: http://www.postgresql.org/about/donate > -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
