http://www.perlmonks.org?node_id=229094


in reply to Re:x2 Escaping parentheses in regexps (select distinct is a Red Flag)
in thread Escaping parentheses in regexps

Thanks grinder; that is a good point. If you are doing a select distinct often (which, if you are putting it in code, you probably are), you probably do want to rethink your query. You may even find that in order to rethink your query, you may need to rethink your schema. Have fun :-)

Scott
Project coordinator of the Generic Model Organism Database Project

Replies are listed 'Best First'.
Re: Re: Re:x2 Escaping parentheses in regexps (select distinct is a Red Flag)
by Tanalis (Curate) on Jan 22, 2003 at 19:07 UTC
    A SELECT DISTINCT isn't possible in this case, though it's a good idea and something we'd thought of.

    The DB we're using is global, and belongs to a different group to the one I work in. It has data stored how they need it for their reporting, not how we need it for ours - hence the need to concatenate data when duplicates occur on one (of our) orderids.

    It's for a fairly specific use, actually: we're trying to have their systems interface with ours for reconciliation purposes, and it's proving to be a lot less simple than I originally thought :)

    It'd make a lot more sense if the company had data storage standards, as we're all essentially in different areas of the the same business, but that'd make life easy ... *grin*

    -- Foxcub