[SQL] confounding, incorrect constraint error

2001-09-22 Thread Kevin Way
I've hit some really evil nastiness that is either a Postgres 7.1.3 bug, or signs of early-onset senility for me. I was having trouble with my database dying while inserting some values, and running some PL/pgSQL. The schema is as listed below, and I'm getting psql:fuck.sql:175: ERROR: ExecRep

Re: [SQL] more information on JOINs

2001-09-22 Thread Stephan Szabo
On Sat, 22 Sep 2001, postgresql wrote: > > Thanks for this reference, I have been here. I guess my problem is > that I don't understand a need for a 'join' that is returning NULLs. If I > understandJOINs correctly, they are returning > columns that contain NULLs. > > An example please

Re: [SQL] more information on JOINs

2001-09-22 Thread postgresql
Thanks for this reference, I have been here. I guess my problem is that I don't understand a need for a 'join' that is returning NULLs. If I understandJOINs correctly, they are returning columns that contain NULLs. An example please where I would want this result. I have created a job

Re: [SQL] more information on JOINs

2001-09-22 Thread Francesco Casadei
On Sat, Sep 22, 2001 at 08:11:03AM -0400, postgresql wrote: > Where can I get more information and examples on using JOINs. I > have been reading over the Chapter 2 on from the interactive user > docs but I need a little more in the way of examples. I am having a > problem understanding when

[SQL] more information on JOINs

2001-09-22 Thread postgresql
Where can I get more information and examples on using JOINs. I have been reading over the Chapter 2 on from the interactive user docs but I need a little more in the way of examples. I am having a problem understanding when I would need a LEFT or RIGHT JOIN. Please, a 'point' in the right