Re: Rewritten queries

 --- Keith Worthington <keithw@narrowpathinc.com>
escribió:
> Hi All,
>
> I wrote a query that created a view and when I
> looked at it in the database
> the SELECT statement was very different.  In part
>
> SELECT items.id,
>        COALESCE(sales.sum, 0) AS committed,
>        COALESCE(purchases.sum, 0) AS on_order,
>        COALESCE(stock.quantity, 0) AS on_hand
>   FROM peachtree.tbl_item AS items...
>
> was changed to
>
> CREATE OR REPLACE VIEW interface.view_inventory AS
>
>  SELECT items.id,
>         CASE
>             WHEN (sales.sum IS NOT NULL ) THEN
> sales.sum
>             WHEN (0 IS NOT NULL ) THEN (0 )::real
>             ELSE NULL::real
>         END  AS "committed",
>         CASE
>             WHEN (purchases.sum IS NOT NULL ) THEN
> purchases.sum
>             WHEN (0 IS NOT NULL ) THEN (0 )::real
>             ELSE NULL::real
>         END  AS on_order,
>         CASE
>             WHEN (stock.quantity IS NOT NULL ) THEN
> stock.quantity
>             WHEN (0 IS NOT NULL ) THEN (0 )::real
>             ELSE NULL::real
>         END  AS on_hand
>    FROM (((peachtree.tbl_item items
>
What version of postgres are u using?
I don't see that particular behavior in coalesce.

someone knows if this is the behavior in any older
version of pg?

regards,
Jaime Casanova

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com