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
If he's using a restriction upon an outer joined table in the where clause
it might be returning results like it was an inner join, ie:
select * from A left outer join B on A.id=B.id
where B.accessed>'2005-10-31';
Instead you'd want to check for the outer joined field having a null
value in the w
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
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
