Thank you Adrian, with \sf+ words_skip_game(integer, integer) the line 85
was correct
On 06/26/2017 01:10 PM, Paul A Jungwirth wrote:
On Mon, Jun 26, 2017 at 12:47 PM, Adrian Klaver
wrote:
On 06/26/2017 12:03 PM, Paul Jungwirth wrote:
Perhaps
you should see what is line 85 when you do `\sf words_skip_game` (rather
than line 85 in your own source code).
Or easier yet:
https:/
On 06/26/2017 01:10 PM, Paul A Jungwirth wrote:
On Mon, Jun 26, 2017 at 12:47 PM, Adrian Klaver
wrote:
On 06/26/2017 12:03 PM, Paul Jungwirth wrote:
Perhaps
you should see what is line 85 when you do `\sf words_skip_game` (rather
than line 85 in your own source code).
Or easier yet:
https:/
On Mon, Jun 26, 2017 at 12:47 PM, Adrian Klaver
wrote:
> On 06/26/2017 12:03 PM, Paul Jungwirth wrote:
>> Perhaps
>> you should see what is line 85 when you do `\sf words_skip_game` (rather
>> than line 85 in your own source code).
>
> Or easier yet:
>
> https://www.postgresql.org/docs/9.5/static/
On 06/26/2017 12:03 PM, Paul Jungwirth wrote:
On 06/26/2017 11:21 AM, Alexander Farber wrote:
The error message returned by
the database is rather cryptic:
words=> select * from words_skip_game(1, 1);
ERROR: query returned no rows
CONTEXT: PL/pgSQL function words_skip_game(integer,integer) li
On 06/26/2017 11:21 AM, Alexander Farber wrote:
The error message returned by
the database is rather cryptic:
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 sourc
In my case _opponent was NULL and there are no records in words_users with
PK uid being NULL... so that was the reason.
Thank you
Hi again,
On Mon, Jun 26, 2017 at 8:21 PM, Alexander Farber <
alexander.far...@gmail.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
On Mon, Jun 26, 2017 at 8:39 PM, Moreno Andreo
wrote:
> Il 26/06/2017 20:21, Alexander Farber ha scritto:
>
>>
>> RETURNING
>> player1,
>> score2,
>> score1
>> INTO
>> _
Il 26/06/2017 20:21, Alexander Farber ha scritto:
RETURNING
player1,
score2,
score1
INTO
_opponent,
_score1, -- the line 85
Good evening,
with PostgreSQL 9.5 I have extended a larger custom function, which has
worked well before and my problem is that the error message returned by the
database is rather cryptic:
words=> select * from words_skip_game(1, 1);
ERROR: query returned no rows
CONTEXT: PL/pgSQL function wor
11 matches
Mail list logo
