including limited lines depending on input parameter
От | kvnsmnsn@cs.byu.edu |
---|---|
Тема | including limited lines depending on input parameter |
Дата | |
Msg-id | 37084.67.137.192.66.1177690238.squirrel@mail.cs.byu.edu обсуждение исходный текст |
Ответы |
Re: including limited lines depending on input parameter
|
Список | pgsql-novice |
Hello all, Okay, this is me back again regarding those two tables I needed to join again, <abc> and <def>. Once these tables are joined together the resulting table has two fields of interest, <n> and <p>. There can be multiple <p> values for one <n> value. I have an input parame- ter <i> that can have three values, 1, 2, or 3+. Based on <i> I need to include in the output table either one <p> value for each <n> va- lue (as far as I know chosen at random) if one exists, two <p> values for each <n> value (again chosen at random) if two exist, or all <p> values for each <n> value, respectively. Does anyone know how I would go about generating such an output table? I have a book _Practical PostgreSQL_ that I thought would help me figure out how to do this (since my SQL server is PostgreSQL), but so far it has been no use. Any information on this would be greatly ap- preciated. ---Kevin Simonson "You'll never get to heaven, or even to LA, if you don't believe there's a way." from _Why Not_
В списке pgsql-novice по дате отправления: