oidrand question
| От | Darren Greer |
|---|---|
| Тема | oidrand question |
| Дата | |
| Msg-id | 9906230705310F.13060@george обсуждение исходный текст |
| Список | pgsql-sql |
Hello again all. First I would like to thank all those who helped me with the multiple select statement. Thanks to your help, it is working fine. I am in the process of using oidrand inside of a select statement. However, I am noticing some wierd results when I feed certain numbers in. Here is a sample select statement. select * from listeners where station = 'KKLS' and oidrand(oid, 2); This returns, as expected, about 50% of the results. Another:select * from listeners where station = 'KKLS' and oidrand(oid,3); This return about 33%. Now lets say that I want to get 75% of the results. I would put 1.333 in there, but it does not return 75%, it return 100%. This tells me that this is rounding to the nearest whole number. If so, how does one get say 75% of the results? Thanks, Darren
В списке pgsql-sql по дате отправления: