"Andrus" <[EMAIL PROTECTED]> writes:
> User interface need to show nulls as empty strings.
> PostgreSQL sorts nulls after all data.
>...
> Select statements are generated dynamically by driver and it is not easy
> to change them to generate order by coalesce( testcol,'').
You could use NULLS FIRS
On Mon, Apr 28, 2008 at 08:05:45PM +0300, Andrus wrote:
> User interface need to show nulls as empty strings.
> PostgreSQL sorts nulls after all data.
>
> create temp table test ( testcol char(10) );
> insert into test values ( null);
> insert into test values ( 'test');
> insert into test values
User interface need to show nulls as empty strings.
PostgreSQL sorts nulls after all data.
create temp table test ( testcol char(10) );
insert into test values ( null);
insert into test values ( 'test');
insert into test values ( '');
select * from test order by testcol;
This confuses users who e
Andrus wrote:
User interface need to show nulls as empty strings.
PostgreSQL sorts nulls after all data.
create temp table test ( testcol char(10) );
insert into test values ( null);
insert into test values ( 'test');
insert into test values ( '');
select * from test order by testcol;
This conf
