[GENERAL] $Body$

2009-08-30 Thread bilal ghayyad
Hi List; What does it mean the $BODY$ when writing the function? In other words: why to use the $ sign? Regards Bilal -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] $Body$

2009-08-30 Thread Christophe Pettus
It's just a string constant: http://www.postgresql.org/docs/8.4/interactive/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS It could be anything between the dollar signs, but BODY is self- documenting. On Aug 30, 2009, at 3:37 PM, bilal ghayyad wrote: Hi List; What does it mean the

Re: [GENERAL] $Body$

2009-08-30 Thread David Fetter
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. --

Re: [GENERAL] $Body$

2009-08-30 Thread bilal ghayyad
this will not be needed in the dolar-quoted string? Regards Bilal --- On Sun, 8/30/09, David Fetter da...@fetter.org wrote: From: David Fetter da...@fetter.org Subject: Re: [GENERAL] $Body$ To: bilal ghayyad bilmar...@yahoo.com Cc: pgsql-general@postgresql.org Date: Sunday, August 30, 2009, 6

Re: [GENERAL] $Body$

2009-08-30 Thread David Fetter
On Sun, Aug 30, 2009 at 04:13:18PM -0700, bilal ghayyad wrote: 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$$? The string BODY in $BODY$ has