Thankx everybody
It worked...
-Message d'origine-
De : Oliveiros [mailto:oliveiros.crist...@marktest.pt]
Envoyé : mercredi 21 avril 2010 15:42
À : Thomas BOURIMECH; pgsql-sql@postgresql.org; Oliveiros
Objet : Re: [SQL] LEFT OUTER JOIN issue
Try moving the hp.poste_idposte=275 inside
Hi everyone, here is my problem :
I got two tables :
CREATE TABLE public.calendar_temp (
id SERIAL,
dat DATE,
heur TIME WITHOUT TIME ZONE,
CONSTRAINT calendar_temp_pkey PRIMARY KEY(id)
) WITHOUT OIDS;
CREATE TABLE public.h_part (
idh SERIAL,
poste_idposte INTEGER NOT NULL,
t
Hi everyone, here is my problem :
I got two tables :
CREATE TABLE public.calendar_temp (
id SERIAL,
dat DATE,
heur TIME WITHOUT TIME ZONE,
CONSTRAINT calendar_temp_pkey PRIMARY KEY(id)
) WITHOUT OIDS;
CREATE TABLE public.h_part (
idh SERIAL,
poste_idposte INTEGER NOT NULL,
t