Re: query has no destination for result data

> On Mar 6, 2019, at 10:29 AM, Adrian Klaver wrote: > > On 3/6/19 8:19 AM, Rob Sargent wrote: >>> On Mar 6, 2019, at 7:41 AM, Adrian Klaver >> > wrote: >>> On 3/6/19 7:37 AM, Pavel Stehule wrote: or \sf+ functioname >>> >>> Cool, I learn

Re: query has no destination for result data

On 3/6/19 8:19 AM, Rob Sargent wrote: On Mar 6, 2019, at 7:41 AM, Adrian Klaver > wrote: On 3/6/19 7:37 AM, Pavel Stehule wrote: or \sf+ functioname Cool, I learned something new. Regards Pavel using \ef function 65 puts the cursor on the first lin

Re: query has no destination for result data

> On Mar 6, 2019, at 7:41 AM, Adrian Klaver wrote: > > On 3/6/19 7:37 AM, Pavel Stehule wrote: > >> or >> \sf+ functioname > > Cool, I learned something new. > >> Regards >> Pavel > > using \ef function 65 puts the cursor on the first line of the loop. So a debugging statement got in the

Re: query has no destination for result data

On 3/6/19 7:37 AM, Pavel Stehule wrote: or \sf+ functioname Cool, I learned something new. Regards Pavel -- Adrian Klaver adrian.kla...@aklaver.com

Re: query has no destination for result data

I believe language plpgsql is not considered part of the function body > so it is not included in the line count: > > https://www.postgresql.org/docs/10/plpgsql-structure.html > > When tracking a line number down I usually do: > > \ef some_function line_number > > which counts the line in the funct

Re: query has no destination for result data

On 3/6/19 7:12 AM, Rob Sargent wrote: On Mar 6, 2019, at 6:32 AM, Ron wrote: On 3/6/19 1:45 AM, Rob Sargent wrote: [snip] This construct had been working until recent changes but I cannot relate the message to any deformity in the current schema or code. Any pointers appreciated. What we

Re: query has no destination for result data

On 3/5/19 11:45 PM, Rob Sargent wrote: I’m using 10.7. Does an empty result set generate this error by any chance. One of my plpgsql functions is now throwing this error: select * from genome_threshold_mono('11-O3C.pbs','1-O3C_chr',1.96, 100); The above is the function you started

Re: query has no destination for result data

> On Mar 6, 2019, at 6:32 AM, Ron wrote: > > On 3/6/19 1:45 AM, Rob Sargent wrote: > [snip] >> This construct had been working until recent changes but I cannot relate the >> message to any deformity in the current schema or code. >> Any pointers appreciated. > > What were the recent changes

Re: query has no destination for result data

> On Mar 6, 2019, at 6:29 AM, Tom Lane wrote: > > Rob Sargent writes: >> One of my plpgsql functions is now throwing this error: > >> ERROR: query has no destination for result data >> HINT: If you want to discard the results of a SELECT, use PERFORM instead. >> CONTEXT: PL/pgSQL function

Re: query has no destination for result data

On 3/6/19 1:45 AM, Rob Sargent wrote: [snip] This construct had been working until recent changes but I cannot relate the message to any deformity in the current schema or code. Any pointers appreciated. What were the recent changes? -- Angular momentum makes the world go 'round.

Re: query has no destination for result data

Rob Sargent writes: > One of my plpgsql functions is now throwing this error: > ERROR: query has no destination for result data > HINT: If you want to discard the results of a SELECT, use PERFORM instead. > CONTEXT: PL/pgSQL function optimal_pvalue_mono(text,text,integer,double > precision,in