Re: RAISE concatination/variables in plpgsql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>, "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: RAISE concatination/variables in plpgsql
Date: 2001-05-08 00:15:22
Message-ID: 24194.989280922@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I wrote:
>> Probably. And 'format' is even more misleading, since it implies that
>> you write a printf-like format string, which you do not. The output is
>> just the concatenation of the literal and the variable values.

Ugh. Should've read the code before pontificating ;-). The code makes
clear what is quite unclear in the docs:
/*
* Occurences of a single % are replaced by the next arguments
* external representation. Double %'s are left as is so elog()
* will also don't touch them.
*/
So "format" is appropriate, but the next sentence could use some
improvement.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-05-08 00:28:33 Re: Re: backend dies on 7.1.1 loading large datamodel.
Previous Message Bruce Momjian 2001-05-08 00:08:26 Re: RAISE concatination/variables in plpgsql