On Mon, Apr 11, 2022 at 7:20 AM Tom Lane wrote:
> PALAYRET Jacques writes:
> > For me, one of the two following things should be true : either the hint
> (in case of a lateral error) is incomplete or the possibility of " cross
> join lateral " should be removed.
>
> The reason the hint is wor
PALAYRET Jacques writes:
> For me, one of the two following things should be true : either the hint (in
> case of a lateral error) is incomplete or the possibility of " cross join
> lateral " should be removed.
The reason the hint is worded the way it is is a practical one: the other
possibili
;)
) u(d1) ON true
;
c1 | d1 | column2
++-
a | b | a
a | c | a*
b | b | b
b | c | b*
(4 lignes)
Regards
De: "David G. Johnston"
À: "PALAYRET Jacques"
Cc: "pgsql-general"
Envoyé: Vendredi 8 Avril 2022 15:36:34
Objet: Re: PostgreSQL : er
On Fri, Apr 8, 2022 at 1:29 AM PALAYRET Jacques
wrote:
> For a LATERAL join, I think the hint (in case of error) is incomplete :
>
> " DÉTAIL : The combining JOIN type must be INNER or LEFT for a LATERAL
> reference. "
> to be replaced by :
> " DÉTAIL : The combining JOIN type must be CROSS, INN
Hello,
For a LATERAL join, I think the hint (in case of error) is incomplete :
" DÉTAIL : The combining JOIN type must be INNER or LEFT for a LATERAL
reference. "
to be replaced by :
" DÉTAIL : The combining JOIN type must be CROSS, INNER or LEFT for a LATERAL
reference. "
Note : it depen
