Skip site navigation (1) Skip section navigation (2)

Re: $Body$

From: bilal ghayyad <bilmar_gh(at)yahoo(dot)com>
To: David Fetter <david(at)fetter(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: $Body$
Date: 2009-08-30 23:13:18
Message-ID: 598552.38359.qm@web53908.mail.re2.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
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 <david(at)fetter(dot)org> wrote:

> From: David Fetter <david(at)fetter(dot)org>
> Subject: Re: [GENERAL] $Body$
> To: "bilal ghayyad" <bilmar_gh(at)yahoo(dot)com>
> Cc: pgsql-general(at)postgresql(dot)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(at)fetter(dot)org>
> http://fetter.org/
> Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!:
> dfetter
> Skype: davidfetter      XMPP: david(dot)fetter(at)gmail(dot)com
> 
> Remember to vote!
> Consider donating to Postgres: http://www.postgresql.org/about/donate
> 


      

In response to

  • Re: $Body$ at 2009-08-30 22:44:54 from David Fetter

Responses

  • Re: $Body$ at 2009-08-30 23:22:09 from David Fetter

pgsql-general by date

Next:From: David FetterDate: 2009-08-30 23:22:09
Subject: Re: $Body$
Previous:From: Marcus EngeneDate: 2009-08-30 22:54:35
Subject: short circuit joins

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group