On Fri, Aug 08, 2003 at 09:17:05AM +0800, Christopher Kings-Lynne wrote:
> australia=# \d affiliates_transactions
> View "public.affiliates_transactions"
[...]
> View definition:
> SELECT palm_buyers.affiliate_id, timestamptz(abstime(palm_buyers.datetime))
> AS
> date, 'Palm' AS "type", 1 AS type_id, palm_buyers.affiliate_amount AS amount
> FROM palm_buyers
> WHERE palm_buyers.affiliate_id IS NOT NULL AND
> palm_buyers.affiliate_amount IS
> NOT NULL
> UNION ALL
> SELECT palm_buyers.affiliate_id,
> timestamptz(abstime(palm_buyers.refund_datetim
> e)) AS date, 'Palm Refund' AS "type", 2 AS type_id, -
> palm_buyers.affiliate_amou
> nt AS amount
Is this the real output or you were bitten by cut&paste wrapping? It
doesn't look good to me as is...
[several other cases in the rest of the definition]
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"The ability to monopolize a planet is insignificant
next to the power of the source"
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
