Simple sql question
| От | Tore Lukashaugen |
|---|---|
| Тема | Simple sql question |
| Дата | |
| Msg-id | fe0lfo$1ov9$1@news.hub.org обсуждение |
| Ответы |
Re: Simple sql question
Re: Simple sql question Re: Simple sql question |
| Список | pgsql-novice |
Hello, I am new to Postgres and have an embarassingly simple question. I am running v8.2 on Windows Vista although I don't think that has any bearing on the answer. create table test (col1 int, col2 int) insert into test values (1,2); select col1/col2 from test....yields 0 not 0.5 - why? Presumably this is because both col1 and col2 are ints and the output needs to be casted somehow? Or is it because PGAdmin's SQL interface does not by default show the decimal places of output? Appreciate your help. Tore
В списке pgsql-novice по дате отправления: