Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

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

by scain (Curate)
on Jan 22, 2003 at 17:51 UTC ( #229094=note: print w/ replies, xml ) Need Help??


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


Comment on Re: Re:x2 Escaping parentheses in regexps (select distinct is a Red Flag)
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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://229094]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (12)
As of 2014-07-24 07:52 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (158 votes), past polls