Re: query has no destination for result data - Mailing list pgsql-general

> On Mar 6, 2019, at 10:29 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> On 3/6/19 8:19 AM, Rob Sargent wrote:
>>> On Mar 6, 2019, at 7:41 AM, Adrian Klaver <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> 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 way!  I
don’tneed the variables set other than to keep track of what’s going on in the loop. They’re gone now and so it the
problem(and hopefully I’ll correct my ways). 
>
> Where you maybe needing SELECT INTO?:
>
> https://www.postgresql.org/docs/10/plpgsql-statements.html#PLPGSQL-STATEMENTS-SQL-ONEROW
>
> So something like(not tested):
>
> select min(ordinal), max(ordinal) into imkr, jmkr from mrkidx where ordinal between segp.firstmarker and
segp.lastmarker;
>
Quite likely but I really don’t need the assignment so the problem is gone.


>> Thank you all.
>>       raise notice '%: added % segments to imputed_pvalue_t',
>>    clock_timestamp(), rcount;
>>    --
>>       for segp in
>>         select s.id <http://s.id>, s.firstmarker, s.lastmarker,
>>                v.ipv,
>>                array_length(p.probands,1) as pbs,
>>                s.lastmarker - s.firstmarker as mks
>>         from segment s
>>              join imputed_pvalue_t v on s.id <http://s.id> = v.segment_id
>>              join probandset p on s.probandset_id = p.id <http://p.id>
>>              join probandset_group_member m on p.id <http://p.id> =
>>    m.member_id
>>         where s.markerset_id = mkset
>>               and m.group_id = pbsgid
>>         order by ipv, pbs, mks
>>       LOOP
>>    _select imkr=min(ordinal), jmkr=max(ordinal) from mrkidx where
>>    ordinal between segp.firstmarker and segp.lastmarker;_
>>         raise notice 'seg % start=% i=% end=% j=%', segp.id
>>    <http://segp.id>, segp.firstmarker, imkr, segp.lastmarker, jmkr;
>>         delete from mrkidx where ordinal between segp.firstmarker and
>>    segp.lastmarker;
>>         get diagnostics rcount = ROW_COUNT;
>>         segsdone = segsdone + 1;
>>         if rcount > 0 then
>>            insert into collected values(segp.id <http://segp.id>,
>>    segp.ipv);
>>            totalinserts = totalinserts + rcount;
>>            if totalinserts = mkrcnt then  -- really totalDELETES
>>               raise notice '%: no markers left on %th segment %',
>>    clock_timestamp(), segsdone, segp.id <http://segp.id>;
>>               exit;
>>            end if;
>>         end if;
>>       end loop;
>>> --
>>> Adrian Klaver
>>> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com