10x for the replies.
We find the problem. It is in our scripts.
We use to_char over a date field and then order by this field. So it sort it as text and not as date.
I appologize for loosing your time.
10x again.
---(end of broadcast)---
TIP 2: you
Kaloyan Iliev Iliev <[EMAIL PROTECTED]> writes:
> As I say in my previous letter I am using 7.2.3. If you wish I can show
> you the query and the result to see for yourself, that there is
> something wrong. It just don't order the overall result but the separate
> results of the both subqueries.
Kaloyan Iliev Iliev wrote:
Dear friends...,
I have the following problem:
select . from where
UNION ALL
select ... from where
ORDER BY field1
But the the order by doesn't work properly. It returns the rows of the
first query ordered and then appends the rows of the
Kaloyan Iliev Iliev <[EMAIL PROTECTED]> writes:
> I have the following problem:
> select
> .
> from
>
> where
>
> UNION ALL
> select
> ...
> from
>
> where
>
> ORDER BY field1
> But the the order by doesn't work properly. It returns the rows of the
> first query ordere
Dear Tom,
As I say in my previous letter I am using 7.2.3. If you wish I can show
you the query and the result to see for yourself, that there is
something wrong. It just don't order the overall result but the separate
results of the both subqueries.
Tom Lane wrote:
Kaloyan Iliev Iliev <[EMAIL
Hello again,
I am using Postgres 7.2.3. If any other details are necessary I will
provide them:)))
10x again
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Dear friends...,
I have the following problem:
select
.
from
where
UNION ALL
select
...
from
where
ORDER BY field1
But the the order by doesn't work properly. It returns the rows of the
first query ordered and then appends the rows of the second query
ordered. But this is
