| From: | <me(at)alternize(dot)com> | 
|---|---|
| To: | <pgsql-novice(at)postgresql(dot)org> | 
| Subject: | changing null-values' sort order | 
| Date: | 2005-11-20 00:31:57 | 
| Message-ID: | 042801c5ed69$f15f70c0$0201a8c0@iwing | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-novice | 
hi list
coming from the MS-SQL Server world, we're migrating our applications slowly to pgsql 8.1. now we thumbled on a problem with different sort-order behaviours:
we got a table with dated records: 
table: votes (v_userid, v_date)
the v_date field can either be null or a date in the past. in mssql, sorting the table to list records in descending date-order
select v_date, v_userid from votes order by v_date desc
produces a list where first the records with dates are listed, and then the ones with nulls. in pgsql, the null-records are listed first before the date-records... how can this behaviour be changed?
mssql:
--------
2005-11-05  3
2005-11-01  4
2005-09-10  1
null  2
null  5
pgsql:
--------
null  2
null  5
2005-11-05  3
2005-11-01  4
2005-09-10  1
thanks in advance,
thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roland Giesler | 2005-11-20 06:22:08 | Re: Large Objects in table | 
| Previous Message | Marcus Engene | 2005-11-19 22:45:42 | Re: Application using PostgreSQL as a back end (experienced |