Обсуждение: Left Joins
How can I use LEFT JOINS with postgresql? Is there a command to do LEFT JOINS with postgresql? Thanks -- Francisco Eriko Barreto Brito Adm Banco de Dados Grupo Radix Tel: (55 81) 3271-6232 eriko@radix.com.br www.radix.com.br
Francisco Eriko Barreto Brito writes: > How can I use LEFT JOINS with postgresql? > > Is there a command to do LEFT JOINS with postgresql? http://www.de.postgresql.org/users-lounge/docs/7.1/postgres/queries.html#QUERIES-FROM -- Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
On Tuesday, September 18, 2001, at 06:23 AM, Francisco Eriko Barreto Brito wrote: > How can I use LEFT JOINS with postgresql? > > Is there a command to do LEFT JOINS with postgresql? > Upgrade to 7.1 (7.1.3 is the latest I think) this allows you to use syntax like: SELECT y.bar, x.foo FROM tbly y LEFT JOIN tblx x ON x.id = y.xid ============================== David Stanaway Personal: david@stanaway.net Work: david@netventures.com.au
I have followed the instructions in the Bruje Momjian´s book to register a function, and i got this message: ERROR:/load of file /home/postgres/ctof.so failed: /home/postgres/ctof.so ELF file´s phentsize not the expected size. What is going on? I have tried to get more documentation about how to use C functions in PostgreSQL, but I cant. Many thanks in advance Miguel