COALESCE in ORDER BY... - Mailing list pgsql-sql

From Terry Yapt
Subject COALESCE in ORDER BY...
Date
Msg-id 1053189601.81a4c98pgsql@technovell.com
Whole thread Raw
Responses Re: COALESCE in ORDER BY...  (Andreas Schmitz <andreas.schmitz@as-dataservice.de>)
List pgsql-sql
Why this doesn't run on postrgreSQL 7.3.1 ?

www=> SELECT 10 AS first ORDER BY first DESC;                            first
-------   10
(1 row)

www=> SELECT 10 AS first ORDER BY COALESCE(first,0) DESC;
ERROR:  Attribute "first" not found

Thanks in advance..



pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: JOIN vs. WHERE ... IN (subselect)
Next
From: Andreas Schmitz
Date:
Subject: Re: COALESCE in ORDER BY...