From: | s <smarie(at)ekno(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | ordering error in query? |
Date: | 2002-06-26 17:50:44 |
Message-ID: | 1025113844.3d19fef4d5121@www.ekno.lonelyplanet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am trying to keep my select statements compatible for running on
oracle or postgres. I ran into a problem with a query that is part of
a union. The original query clause is of the form:
select distinct f.id, '' from foo f;
I need the empty string as the second attribute because the first part
of the union has a second attribute. This works on oracle, but
postgres says:
ERROR: Unable to identify an ordering operator '<' for type 'unknown'
Use an explicit ordering operator or modify the query
If I get rid of 'distinct' postgres responds, but I don't get the
result I want. If I type
select distinct s.ben, cast ('' as varchar) from sitealertsview s;
I get the result I want, but it's not compatible with oracle.
Suggestions?
Thanks,
Sarah
smarie(at)ekno(dot)com
____________________________________________________________________________
Lonely Planet's ekno - more than a phonecard
Get ekno before you go!
http://www.ekno.lonelyplanet.com
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-06-26 17:54:47 | Re: Shared Memory Sizing |
Previous Message | Alvaro Herrera | 2002-06-26 17:49:38 | Re: How to run multi-processor question |