Left Joins

Поиск
Список
Период
Сортировка
Искать

Left Joins

От:
Francisco Eriko Barreto Brito <eriko@radix.com.br>
Дата:
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

От:
Peter Eisentraut <peter_e@gmx.net>
Дата:
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

От:
David Stanaway <david@netventures.com.au>
Дата:

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

От:
Miguel González <iafmgc@unileon.es>
Дата:
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


FAQ