Re: [SQL] to_char() and order-by

2002-06-28 Thread Karel Zak
On Thu, Jun 27, 2002 at 12:27:11PM -0700, Jeff Boes wrote: > Perhaps this was covered in the 7.2.x release notes, but it's mystifying us: Please, how are data without to_char()? select time_link from stat_fetch where time_link is not null order by 1 desc limit 10; Karel > select to

[SQL] creating functional index over multiple columns

2002-06-28 Thread Chantal Ackermann
hello all, I am new to this list, and I hope my request is well placed, here. I tried searching the archives but I wasn't lucky. I want to create an index over two columns and one function: the WHERE clause is: WHERE lower(name)=? AND type_id=? AND syn_id=? I know from the docs that I have to