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

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 the

[SQL] LEFT OUTER JOIN issue

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

--- On Wed, 4/21/10, Thomas BOURIMECH wrote: From: Thomas BOURIMECH Subject: [SQL] LEFT OUTER JOIN issue To: "'pgsql-sql@postgresql.org'" Date: Wednesday, April 21, 2010, 9:06 AM Hi  everyone, here is my problem :   I got two tables :   CREATE TABLE "public"."calendar_t

Re: [SQL] LEFT OUTER JOIN issue

Le Wed, 21 Apr 2010 11:06:25 +0200, Thomas BOURIMECH a écrit : > 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") > ) WI

[SQL] Inconsistent Nested Set Moves

Hi folks: I am working on a nested set implementation using some of theadvice I found in the archives, namely in this thread: http://archives.postgresql.org/pgsql-sql/2002-11/msg00358.php However, I don't seem to be able to get consistent results. More than half the time I get a duplicate primar