[SQL] LEFT OUTER JOIN issue

2010-04-22 Thread Thomas BOURIMECH
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" INTE

Re: [SQL] LEFT OUTER JOIN issue [SOLVED]

2010-04-22 Thread Thomas BOURIMECH
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 insid

[SQL] LEFT OUTER JOIN issue

2010-04-21 Thread Thomas BOURIMECH
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" INTE