On Fri, Jun 22, 2007 at 08:30:07PM -, Michael Bayer wrote:
the contents of the columns clause is configurable via the select()
construct directly:
result=select([records_a, records_ptr],
records_a.c.type=='A',
from_obj=[model.outerjoin(records_a, records_ptr,
(
im not sure if full outer join is really available on most databases.
On Jun 23, 5:12 am, Christoph Haas [EMAIL PROTECTED] wrote:
On Fri, Jun 22, 2007 at 08:30:07PM -, Michael Bayer wrote:
the contents of the columns clause is configurable via the select()
construct directly:
On Jun 23, 6:18 am, Michael Bayer [EMAIL PROTECTED] wrote:
im not sure if full outer join is really available on most databases.
I'm confused by the inclusion of the word really there.
Is it that some of them claim to support a full outer join but what
they deliver is not really the right
On Jun 22, 2007, at 9:59 AM, Christoph Haas wrote:
Dear list,
I'm trying to join a table with itself. That works well. However since
the column names are identical I had no luck accessing both the
original
and the joined information.
I have aliased the tables already and run the join
On Fri, Jun 22, 2007 at 11:50:51AM -0400, Michael Bayer wrote:
On Jun 22, 2007, at 9:59 AM, Christoph Haas wrote:
I'm trying to join a table with itself. That works well. However since
the column names are identical I had no luck accessing both the
original
and the joined
On Fri, Jun 22, 2007 at 04:40:58PM -, Michael Bayer wrote:
On Jun 22, 12:12 pm, Christoph Haas [EMAIL PROTECTED] wrote:
2007-06-22 18:09:57,852 INFO sqlalchemy.engine.base.Engine.0x..6c SELECT
records_a.id, records_a.domain_id, records_a.dhcpzone_id, records_a.name,
records_a.type,
On Jun 22, 12:12 pm, Christoph Haas [EMAIL PROTECTED] wrote:
2007-06-22 18:09:57,852 INFO sqlalchemy.engine.base.Engine.0x..6c SELECT
records_a.id, records_a.domain_id, records_a.dhcpzone_id, records_a.name,
records_a.type, records_a.content, records_a.ttl, records_a.prio,
On Fri, Jun 22, 2007 at 07:22:05PM +0200, Christoph Haas wrote:
On Fri, Jun 22, 2007 at 04:40:58PM -, Michael Bayer wrote:
On Jun 22, 12:12 pm, Christoph Haas [EMAIL PROTECTED] wrote:
2007-06-22 18:09:57,852 INFO sqlalchemy.engine.base.Engine.0x..6c SELECT
records_a.id,
the contents of the columns clause is configurable via the select()
construct directly:
result=select([records_a, records_ptr],
records_a.c.type=='A',
from_obj=[model.outerjoin(records_a, records_ptr,
( (records_a.c.inet==records_ptr.c.inet)
(records_ptr.c.type=='PTR') ))],