Re: [GENERAL] how to emit line number in a function?

2005-11-04 Thread Bricklen Anderson
Jerry Sievers wrote: > Bricklen Anderson <[EMAIL PROTECTED]> writes: > > >>I couldn't find any useful references in the docs or archives for emitting the >>line number of a plpgsql function (in a RAISE statement). I'd like to use it >>for >>debugging some complex functions. >>Does anyone have an

Re: [GENERAL] how to emit line number in a function?

2005-11-04 Thread Jerry Sievers
Bricklen Anderson <[EMAIL PROTECTED]> writes: > I couldn't find any useful references in the docs or archives for emitting the > line number of a plpgsql function (in a RAISE statement). I'd like to use it > for > debugging some complex functions. > Does anyone have any tips on where to look, or

Re: [GENERAL] how to emit line number in a function?

2005-11-03 Thread Bricklen Anderson
Jim C. Nasby wrote: > This seems to be something useful to have... can we get a TODO? Unless > maybe Bricklen wants to submit a patch... :) I can barely even spell C ... -- ___ This e-mail may be privileged and/or confidential, and the sender does not waive any relat

Re: [GENERAL] how to emit line number in a function?

2005-11-03 Thread Jim C. Nasby
On Thu, Nov 03, 2005 at 09:25:27AM -0800, Bricklen Anderson wrote: > Richard Huxton wrote: > > Bricklen Anderson wrote: > > > >>I couldn't find any useful references in the docs or archives for emitting > >>the > >>line number of a plpgsql function (in a RAISE statement). I'd like to use > >>it

Re: [GENERAL] how to emit line number in a function?

2005-11-03 Thread Bricklen Anderson
Richard Huxton wrote: > Bricklen Anderson wrote: > >>I couldn't find any useful references in the docs or archives for emitting the >>line number of a plpgsql function (in a RAISE statement). I'd like to use it >>for >>debugging some complex functions. >>Does anyone have any tips on where to look

Re: [GENERAL] how to emit line number in a function?

2005-11-03 Thread Richard Huxton
Bricklen Anderson wrote: I couldn't find any useful references in the docs or archives for emitting the line number of a plpgsql function (in a RAISE statement). I'd like to use it for debugging some complex functions. Does anyone have any tips on where to look, or an example of this? I don't t

[GENERAL] how to emit line number in a function?

2005-11-03 Thread Bricklen Anderson
I couldn't find any useful references in the docs or archives for emitting the line number of a plpgsql function (in a RAISE statement). I'd like to use it for debugging some complex functions. Does anyone have any tips on where to look, or an example of this? Cheers, Bricklen -- _