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

Re: plpgsql function, comment with single quote, braces

From: Kris Jurka <books(at)ejurka(dot)com>
To: Роман Литовченко <roman(dot)lytovchenko(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org, Florent Guillaume <fg(at)nuxeo(dot)com>, polobo(at)yahoo(dot)com
Subject: Re: plpgsql function, comment with single quote, braces
Date: 2012-01-20 19:25:52
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc

On Fri, 20 Jan 2012, ????? ?????????? wrote:

> [simple example code]
> What about these?

Yes, this is a bug.  The escape processor is getting confused about what 
it should process and is incorrectly modifying your code.  Escape 
processing should only occur in a raw SQL, never within a literal value.  
The escape processor should skip over the entire function body because it 
is within dollar quotes and is a literal, but it doesn't understand dollar 
quotes so it is examining the contents and is getting further confused by 
the single quotes within it.

The parameter locating code (looking for ?) knows about dollar quotes, so 
it would be nice to unify with that instead of having two partial query 

Kris Jurka

In response to

pgsql-jdbc by date

Next:From: John ListerDate: 2012-01-20 19:32:26
Subject: Array helper patch
Previous:From: Vitalii TymchyshynDate: 2012-01-20 14:50:08
Subject: Re: NIO support

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