(damn gmail, sorry about priv mail earlier)
Stephan Szabo <[EMAIL PROTECTED]>:
I think putting a test in an ON clause associated with the join (using
something like ... left join object_values ov1 ON(ov.obj_id = ov1.obj_id
and ov1.att_id=8) rather than where will consider both as part of the joi
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desi
Florian, Thank you so much for your time. You have given me a whole lot
to think about. I suspect you have defined most of the important
aspects of the solution to my problem. I will go and implement this.
Mit freundlichen Grüssen, Willem
---(end of broadcast)-
I have a problem in a number of my tables. I'd like to add uniqueness
constraints across multiple columns, but some of the columns are
nullable. This gives me trouble since when I create a constraint on
columns A and B.. I'd like the constraint to be enforced such that
you couldn't insert v
I have a table that I created that implements a linked list. I am not an
expert SQL developer and was wondering if there are known ways to traverse
the linked lists. The table contains many linked lists based upon the head
of the list and I need to extract all of the nodes that make up a list. T
On Thu, 27 Apr 2006, Phillip Tornroth wrote:
I have a problem in a number of my tables. I'd like to add uniqueness
constraints across multiple columns, but some of the columns are nullable.
This gives me trouble since when I create a constraint on columns A and B..
I'd like the constraint to b
On Sat, Apr 29, 2006 at 13:14:36 -0700,
Jeff Frost <[EMAIL PROTECTED]> wrote:
> On Thu, 27 Apr 2006, Phillip Tornroth wrote:
>
> >I have a problem in a number of my tables. I'd like to add uniqueness
> >constraints across multiple columns, but some of the columns are nullable.
> >This gives me
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> To block multiple entries where one of the columns is null he needs to
> add extra checks. One way to do this is to add a partial index for each column
> with the condition that the other column IS NULL. This will cover everything
> but the case where b
