[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 syntax. You will not

[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 here's

[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 *except* in

[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