[GENERAL] Strange PG error

2001-04-29 Thread Dr. Evil
I was trying to write a function which does a DES encryption for Postgres, which I would then link in as a C function. I got the function more or less working on its own, and then I tried to link it to PG. The first time I executed the function, the backend died. Then, I removed the Unix domain

Re: [GENERAL] Joining more than 2 tables

2001-04-29 Thread Peter Eisentraut
Jeff Meeks writes: > I am trying to join 3 tables > with this query > select a.id, a.name, sum(b.qty), sum(c.qty) > from a, b, c > where a.id=xxx and b.id=a.id and c.id=a.id > > what the sums that get returned look as if they are a cross products of > the b and c tables.