Re: [PERFORM] [GENERAL] Seq scan of table?

2003-09-06 Thread Neil Conway
On Fri, 2003-09-05 at 06:07, Richard Huxton wrote: > PG's parser will assume an explicit number is an int4 - if you need an int8 > etc you'll need to cast it, yes. Or enclose the integer literal in single quotes. > You should find plenty of discussion of why in the archives, but the short > rea

Re: [GENERAL] Needed function IF(expr, expr, expr)

2003-09-06 Thread elein
If the function is defined with ANY* and you defer typing the arguments until the first reference then I think you will get what you want with the CASE statement. If the function is called if( x>y, x+1, y), the first reference is in the argument list and so should be typed there. But if you pas