Michiel Meeuwissen <[EMAIL PROTECTED]> wrote: > Eduard Witteveen <[EMAIL PROTECTED]> wrote: > > something like DISTINCT(CAST(news.number, CHAR) +' '+ CAST(urls.number, > > CHAR)) could be a workaround > > Smart, that could perhaps be the postgresql version then.
Well, actually, in postgresl it seems to work like this: select COUNT(DISTINCT (text(urls.number) || ' ' || text(news.number) )) But the idea is the same. Michiel -- Michiel Meeuwissen Mediapark C101 Hilversum +31 (0)35 6772979 nl_NL eo_XX en_US mihxil' [] ()
