On Tue, Mar 29, 2005 at 14:21:13 +0300, ALİ ÇELİK <[EMAIL PROTECTED]> wrote: > I have used coalesce function for null fields but coalesce is too slow. > I need fast alternative for coalesce
It is unlikely that coalesce is your problem. People might be able to provide some help if you provide EXPLAIN ANALYZE output and the actual query for your slow query. ---------------------------(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