I have a situation where i need to select a couple of rows from an
inherited table
collection. The statement I'm using is:
SELECT * FROM parent NATURAL JOIN interesting
where interesting is a 1 column temporary table with the primary key's
of the rows
I'm interested in.
All the child tables
: tuptoaster.c,
Line: 830)
Ouch!
The actual case that I discovered this on had extra columns in the
derived table and I was expecting some sort of error message (and I
guess I got one - just a little more extreme than I was expecting)
--
Kris Shannon [EMAIL PROTECTED]
---(end
was going to have a stab at it, but after looking at the patch I can see
my knowledge of the internals still leaves a bit to be desired (make that a LOT)
Thanks for this anyway. You just simplified my coding immensely
--
Kris Shannon [EMAIL PROTECTED]
---(end of broadcast
On 5/2/06, Brandon Black [EMAIL PROTECTED] wrote:
On 4/30/06, Heikki Linnakangas [EMAIL PROTECTED] wrote: On Fri, 28 Apr 2006, Brandon Black wrote: I dug around in CVS to have a look for this, and I did eventually find
it (well, I found the corresponding docs patch that removed the note about
: a tool to view the differences between two
diffs!
I wouldn't trust that too much. I've played with it quite a bit and there are
quite a few corner cases where it gives the wrong answer (or at least a
different diff than I get when I manually apply them and then take the diff)
--
Kris Shannon