[SQL] Re: [INTERFACES] outer join in PostgreSql

2001-01-17 Thread Ross J. Reedstrom
On Tue, Jan 16, 2001 at 06:44:18PM +0200, Hannu Krosing wrote: > > To get a feel you could use MS Access visual query builder and then view > the source. > I have not checked it lately, but it very likely produces SQL92 > compliant outer joins. > I fired up MS-Access 97SR1, just to see, and her

[SQL] Re: [INTERFACES] outer join in PostgreSql

2001-01-17 Thread Hannu Krosing
Thomas Lockhart wrote: > > Mauricio Hipp Werner wrote: > > > > 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? > > The PostgreSQL outer join is accomplished using SQL92 synt

[SQL] Re: [INTERFACES] outer join in PostgreSql

2001-01-16 Thread Patrick Welche
On Mon, Jan 15, 2001 at 06:16:00PM -0400, Mauricio Hipp Werner wrote: > 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? I don't really understand your question, but from src/test/regr

[SQL] Re: [INTERFACES] outer join in PostgreSql

2001-01-16 Thread Thomas Lockhart
Mauricio Hipp Werner wrote: > > 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? The PostgreSQL outer join is accomplished using SQL92 syntax. You will not find real outer joins *exce

[SQL] Re: [INTERFACES] outer join in PostgreSql

2001-01-15 Thread Peter Eisentraut
Mauricio Hipp Werner writes: > 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? No symbol, just words. http://www.postgresql.org/devel-corner/docs/postgres/sql-select.htm -- Peter E