On Fri, 5 Aug 2005, D Kavan wrote:
>
> Hi,
>
> Thanks for the reply. That didn't help him, but he asked me to post this.
>
> There are 66 project id's in the project table and 3 rows in the
> project_members table for global_id 2915, but it only returns 3. I would
> think it should return 66 row
D Kavan wrote:
> There are 66 project id's in the project table and 3 rows in the
> project_members table for global_id 2915, but it only returns 3. I
> would think it should return 66 rows, with 63 of them having a null
> pm.project_id.
>
> SELECT
> p.project_id, pm.project_id
> FRO
OTECTED] Behalf Of D Kavan
Sent: Friday, August 05, 2005 3:32 PM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] outer joins
Hi,
Thanks for the reply. That didn't help him, but he asked me to post this.
There are 66 project id's in the project table and 3 rows in the
project_me
Hi,
Thanks for the reply. That didn't help him, but he asked me to post this.
There are 66 project id's in the project table and 3 rows in the
project_members table for global_id 2915, but it only returns 3. I would
think it should return 66 rows, with 63 of them having a null pm.project_id
On Fri, Aug 05, 2005 at 03:55:16PM -0400, D Kavan wrote:
> One the developers is saying that he can't do outer joins on postgresql.
> Is this true? We have postgresql 8.02.
No, that isn't true. PostgreSQL has supported outer joins for a
long time.
> He is using this syntax:
> select from A left
005-10-31');
I assure you, outer joins work just fine on PostgreSQL.
Jason
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of D Kavan
Sent: Friday, August 05, 2005 2:55 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] outer joins
Hi,
One the dev
Hi,
One the developers is saying that he can't do outer joins on postgresql.
Is this true? We have postgresql 8.02.
He is using this syntax:
select from A left outer join b on A.id=B.id;
This processes but comes back with a result like it was an inner join.
~DjK
---
full release is planned for end February, if all goes well ...
On Sat, 3 Feb 2001, Steve Doerr wrote:
> I saw that outer joins will be supported in ver. 7.1. Does anyone know
> when this is expected, or if there is beta support for them currently?
>
> Thanks,
> Steve
>
>
Marc G. Fournier
> "SD" == Steve Doerr <[EMAIL PROTECTED]> writes:
SD> I saw that outer joins will be supported in ver. 7.1. Does anyone know
SD> when this is expected, or if there is beta support for them currently?
Yes, they are supported in 7.1 beta. See doc.
--
Anatoly K. Lasareff Em
I saw that outer joins will be supported in ver. 7.1. Does anyone know
when this is expected, or if there is beta support for them currently?
Thanks,
Steve
Try the following:
SELECT name,firstname,title
FROM TablePerson,TableTitle
WHERE TablePerson.fk_idtitle = TableTitle.pk_idtitle
UNION
SELECT name,firstname,''::varchar(10)
FROM TablePerson
WHERE fk_idtitle IS NULL;
Guido Weber
On Mon, 2 Nov 1998 [EMAIL PROTECTED] wrote:
> Hello,
>
> i
Hello,
is there a possibility to use "outer joins" (left outer join) with pgsql?
I have a problem joining two tables:
TablePerson TableTitle
--- --
pk_idperson int primary key
12 matches
Mail list logo
