Thread: Left Joins

Left Joins

From
Francisco Eriko Barreto Brito
Date:
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




Re: Left Joins

From
Peter Eisentraut
Date:
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


Re: Left Joins

From
David Stanaway
Date:
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

Registring a C function in PostgreSQL

From
Miguel González
Date:
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