From: | Alexander Farber <alexander(dot)farber(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: ERROR: query returned no rows |
Date: | 2017-06-26 18:54:59 |
Message-ID: | CAADeyWiZ4QNKSVffrrXHv8-d_TvTJ-inBRdZh9JP87kKk8UzFg@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi again,
On Mon, Jun 26, 2017 at 8:21 PM, Alexander Farber <
alexander(dot)farber(at)gmail(dot)com> wrote:
>
> words=> select * from words_skip_game(1, 1);
> ERROR: query returned no rows
> CONTEXT: PL/pgSQL function words_skip_game(integer,integer) line 85 at
> SQL statement
>
> When I look at my source code ( https://gist.github.com/afarber/
> cac9a83b7a37307ace8d787be9b8ff4c ) at the line 85, then I am not sure if
> the line number reported by the error message is correct
>
I have added many RAISE NOTICE 'xxxx' lines and now see that the error is
at SELECT ... INTO STRICT.... (which was not the line 85):
SELECT
_opponent,
fcm,
apns,
sns,
CASE
WHEN _skips = 5 THEN 'Противник пропускает
ход (еще один пропуск завершит игру)'
ELSE 'Противник пропускает ход'
END
FROM words_users
WHERE uid = _opponent
INTO STRICT
out_uid,
out_fcm,
out_apns,
out_sns,
out_note;
RETURN NEXT;
Regards
Alex
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Farber | 2017-06-26 18:57:28 | Re: ERROR: query returned no rows |
Previous Message | Alexander Farber | 2017-06-26 18:43:31 | Re: [SPAM] ERROR: query returned no rows |