Re: Overwriting Operator for numeric and float8 fails
От
Andrew McMillan
Тема
Re: Overwriting Operator for numeric and float8 fails
Дата
Msg-id
3B78A80B.BEFD51BD@catalyst.net.nz
Список
Дерево обсуждения
Overwriting Operator for numeric and float8 fails "Johann Zuschlag" <zuschlag@online.de>
standard sql operators harrold@sage.che.pitt.edu
Re: standard sql operators Gaetan GUYODO <gaetan.guyodo@lrb.ap-hop-paris.fr>
Johann Zuschlag wrote:
>
> Hi,
>
> I've got a really stupid question. My application does queries like this:
>
> SELECT t6.* FROM RECHNUNG t6 WHERE t6.bruttosumm = 00000034.70 ORDER BY t6.nummer DESC
>
Can't you just force conversion of the constant to numeric?
SELECT t6.* FROM RECHNUNG t6 WHERE t6.bruttosumm = numeric(00000034.70)
ORDER BY t6.nummer DESC
Cheers,
Andrew.
--
_____________________________________________________________________
Andrew McMillan, e-mail: Andrew @ catalyst . net . nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64(27)246-7091, Fax:+64(4)499-5596, Office: +64(4)499-2267xtn709
В списке pgsql-novice по дате отправления
