On Mon, Oct 04, 2010 at 01:35:49PM -0700, Darren Duncan wrote:
> Reinier Post wrote:
[...]
> ># Failed test 'use Set::Relation;'
> ># at t/Set_Relation_00_Compile.t line 9.
> ># Tried to use 'Set::Relation'.
> ># Error: Can't use an undefined value as a HASH reference at
> ># /usr/
Reinier Post wrote:
SELECT E.*
FROM Employee AS E
LEFT JOIN Dept AS D USING (DeptName)
WHERE D.DeptName IS NULL
Thanks, I didn't know about USING. Works fine, too:
That's good to hear.
Set::Relation is superfluous for this task actually.
I'd like to try it anyway,
but it won't
On Mon, Oct 04, 2010 at 11:12:05AM -0700, Darren Duncan wrote:
> Reiner, I don't know if this was your workaround, but here's another
> solution that just uses SQL::Statement ...
>
> Ludwig, Michael wrote:
> >>So the next thing I tried was the anti-join (see
> >>
> >> http://en.wikipedia.org/wiki
Reiner, I don't know if this was your workaround, but here's another solution
that just uses SQL::Statement ...
Ludwig, Michael wrote:
So the next thing I tried was the anti-join (see
http://en.wikipedia.org/wiki/Relational_algebra#Antijoin
First time I hear of this "antijoin".
The exampl
Reinier Post wrote:
Dear fellow DBI users,
Recently I discovered (by asking on #perl, as usual) that SQL::Statement
supports joins. I like this, because it allows me to compute the
relational join of two CSV tables and store the result as a new CSV table.
Actually, I'd like to apply *all* re
> So the next thing I tried was the anti-join (see
>
> http://en.wikipedia.org/wiki/Relational_algebra#Antijoin
First time I hear of this "antijoin".
The example given on the Wiki page doesn't make much sense
to me. Isn't is simply an OUTER JOIN where you're looking
for NULL on the right-hand
Dear fellow DBI users,
Recently I discovered (by asking on #perl, as usual) that SQL::Statement
supports joins. I like this, because it allows me to compute the
relational join of two CSV tables and store the result as a new CSV table.
Actually, I'd like to apply *all* relational algebra opera
On 10/3/2010 12:45 PM, Eric Yellin wrote:
I have yet to try an build DBD::Oracle for FreeBSD so the Makefile might
not be working correctly here are my comments
Hi,
I am trying to compile DBD::Oracle that will work with Oracle 10g on
FreeBSD 6.3
Here is what I have done so far:
1. I