Re: [SQL] outer join in PostgreSql

2001-01-16 Thread Borek Lupoměský
On Mon, 15 Jan 2001, Mauricio Hipp Werner wrote: MHW> in oracle the is used (+) MHW> in sybase the is used * and MHW> in postgreSql? In PostgreSQL we have no outer joins at all. But it is promised they are going to arrive soon, perhaps in 7.1? Bye Borek --

[SQL] outer join in PostgreSql

2001-01-16 Thread Mauricio Hipp Werner
I need help, which is the symbol used in postgreSql to carry out the outer join. in oracle the is used (+) in sybase the is used * and in postgreSql? thank you Hipp Mauricio

Re: [SQL] Outer join in postgresql

2000-06-12 Thread Jesus Aneiros
There is no OUTER JOIN in postgres. You could use SELECT and UNION ALL. Jesus. On Mon, 12 Jun 2000, Patrick Kay wrote: > I am looking for a way run an outer join in psql. Can anyone help? > > Informix has an "OUTER" keyword. I don't see anything like this in the docs > for psql. > > Thanks

Re: [SQL] Outer join in postgresql

2000-06-12 Thread Robert B. Easter
On Mon, 12 Jun 2000, Patrick Kay wrote: > I am looking for a way run an outer join in psql. Can anyone help? > > Informix has an "OUTER" keyword. I don't see anything like this in the docs > for psql. > > Thanks much. > -Pat Kay Here is an example I have about simulating an outer join in Post

Re: [SQL] Outer join in postgresql

2000-06-12 Thread Bruce Momjian
See the FAQ. It involves UNION. > Patrick Kay wrote: > > > > I am looking for a way run an outer join in psql. Can anyone help? > > > > Informix has an "OUTER" keyword. I don't see anything like this in the docs > > for psql. > > There are many examples on how to do this in the archives or

Re: [SQL] Outer join in postgresql

2000-06-12 Thread Ed Loehr
Patrick Kay wrote: > > I am looking for a way run an outer join in psql. Can anyone help? > > Informix has an "OUTER" keyword. I don't see anything like this in the docs > for psql. There are many examples on how to do this in the archives or via deja.com's power search. Regards, Ed Loehr

Re: [SQL] Outer join in postgresql

2000-06-12 Thread Peter Vazsonyi
On Mon, 12 Jun 2000, Patrick Kay wrote: > I am looking for a way run an outer join in psql. Can anyone help? > > Informix has an "OUTER" keyword. I don't see anything like this in the docs > for psql. > > Thanks much. > -Pat Kay > Hmmm... I don't now the exact definition of outer join. I f

[SQL] Outer join in postgresql

2000-06-12 Thread Patrick Kay
I am looking for a way run an outer join in psql. Can anyone help? Informix has an "OUTER" keyword. I don't see anything like this in the docs for psql. Thanks much. -Pat Kay