InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: InstantDB: order by double


Kirk

I can't think of any good reason why double columns would cause particular
problems in ORDER BY clauses.

What sort of problems are you experiencing? I've attached a very simple
script that does an order by on a double column. Maybe you could edit it to
illustrate the problem.

Regards

Pete

--

Peter Hearty                         peter.hearty@lutris.com
Lutris Technologies (UK)        http://www.lutris.com
----- Original Message -----
From: "Kirk Austin" <kirk@bananas.com>
To: <instantdb@enhydra.org>
Sent: Monday, January 29, 2001 5:33 PM
Subject: InstantDB: order by double


> Is there any reason why "ORDER BY" on a column of type DOUBLE would not
> work when doing a simple select such as:
>
> SELECT PROD_NAME, PROD_PRICE FROM PROD_TABLE ORDER BY PROD_PRICE
>
> Assuming PROD_PRICE has been defined as a column of type DOUBLE.
>
> Thanks,
>
> Kirk Austin
>
> --------------------------------------------------------------------------
---
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.
>


begin 666 sql1.txt
M9"!O<F<N96YH>61R82YI;G-T86YT9&(N:F1B8RYI9&)$<FEV97([#0IO(&ID
M8F,Z:61B/6,Z7&EN<W1A;G1D8EQB=6=S7'-A;7!L92YP<G [#0H-"F4@4T54
M($584$]25" B=')A8V4N;&]G(B!44D%#12 V($-/3E-/3$4[#0H-"F1R;W @
M=&%B;&4@=&5S=#$[#0IC<F5A=&4@=&%B;&4@=&5S=#$@*&ED(&EN="P@9&(Q
M(&1O=6)L92D[#0II;G-E<G0@:6YT;R!T97-T,2!V86QU97,@*#,L(#,N,S,S
M*3L-"FEN<V5R="!I;G1O('1E<W0Q('9A;'5E<R H,BP@,BXR,C(I.PT*:6YS
M97)T(&EN=&\@=&5S=#$@=F%L=65S("@Q+" Q+C$Q,2D[#0IQ('-E;&5C=" J
M(&9R;VT@=&5S=#$[#0IQ('-E;&5C=" J(&9R;VT@=&5S=#$@;W)D97(@8GD@
;9&(Q.PT*#0IC(&-L;W-E.PT*8R!E>&ET.PT*
`
end

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.