Re: [BUGS] RAISE concatination/variables in plpgsql

2001-05-07 Thread Tom Lane
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 c

Re: [BUGS] RAISE concatination/variables in plpgsql

2001-05-07 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: >> Looking at the plpgsql code, it's clear that what's actually implemented >> is >> RAISE level string-literal [ , variable [ , variable [ ... ] ] > I see the current docs showing: > RAISE level 'format' [, identifier [...]]; > Is this acceptable

Re: [BUGS] RAISE concatination/variables in plpgsql

2001-04-19 Thread Tom Lane
"Henshall, Stuart - WCP" <[EMAIL PROTECTED]> writes: > In the plpgsql docs it has the following example: > RAISE NOTICE ''Id number '' || key || '' not found!''; > When I put a function round this statement it gives a compile error at the > |. > Also when fiddling if I put a variable first it com

[BUGS] RAISE concatination/variables in plpgsql

2001-04-19 Thread Henshall, Stuart - WCP
SEVERITY:Minor Anoyance In the plpgsql docs it has the following example: RAISE NOTICE ''Id number '' || key || '' not found!''; When I put a function round this statement it gives a compile error at the |. Also when fiddling if I put a variable first it complains about that variable (eg key || '