pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

full join...using and version of pgsql
2+ messages / 2 participants
[nested] [flat]

* full join...using and version of pgsql
@ 2004-04-14 17:05  Tina Messmann <tina.messmann@xinux.de>
  0 siblings, 1 reply; 2+ messages in thread

From: Tina Messmann @ 2004-04-14 17:05 UTC (permalink / raw)
  To: pgsql-sql

hello list,

i am using pgsql 7.2.1
i need something like

select * from t1 full join t2 using(bla) full join t3 using(bla)

i searched the archives and found that this is not possible with my 
version of postgres.
is this implemented in newer versions of postgres? since which version?

i'll try the alternative select * from t1 full join t2 on(t1.bla=t2.bla) 
full join t3 on(t1/t2.bla=t3.bla)
but this is not the best solution for me i think....

regards
tina




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: full join...using and version of pgsql
@ 2004-04-14 20:39  scott.marlowe <scott.marlowe@ihs.com>
  parent: Tina Messmann <tina.messmann@xinux.de>
  0 siblings, 0 replies; 2+ messages in thread

From: scott.marlowe @ 2004-04-14 20:39 UTC (permalink / raw)
  To: Tina Messmann <tina.messmann@xinux.de>; +Cc: pgsql-sql

On Wed, 14 Apr 2004, Tina Messmann wrote:

> hello list,
> 
> i am using pgsql 7.2.1
> i need something like
> 
> select * from t1 full join t2 using(bla) full join t3 using(bla)
> 
> i searched the archives and found that this is not possible with my 
> version of postgres.
> is this implemented in newer versions of postgres? since which version?
> 
> i'll try the alternative select * from t1 full join t2 on(t1.bla=t2.bla) 
> full join t3 on(t1/t2.bla=t3.bla)
> but this is not the best solution for me i think....

I think you are looking for a natural join.




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2004-04-14 20:39 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-14 17:05 full join...using and version of pgsql Tina Messmann <tina.messmann@xinux.de>
2004-04-14 20:39 ` scott.marlowe <scott.marlowe@ihs.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox