Thread: 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