Postgres Pro
Downloads
Home   >   mailing lists

Re: Forward declaration of table - Mailing list pgsql-general

From David G. Johnston
Subject Re: Forward declaration of table
Date
Msg-id CAKFQuwar=c4FAq4d=SDVHoy9LUtB3tX8ff1g+KrmNusMnWHvCw@mail.gmail.com
Whole thread Raw
In response to Re: Forward declaration of table  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
On Wed, Aug 24, 2016 at 4:38 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wed, Aug 24, 2016 at 4:27 PM, Alexander Farber <alexander.farber@gmail.com> wrote:

Why aren't m.tiles and m.score returned please?


​How about you output g.mid1 and g.mid2 in the first query and confirm that the rows being returned from words_games actually have a value in the set {2,3,4} in one of those columns.


​Also, NULL can be annoying here...might want to try IS DISTINCT FROM or some similar.

Dave
​
 

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Forward declaration of table
Next
From: Francisco Reyes
Date:
Subject: Alter default privileges vs new schemas