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 > reason is that PG's type structure is quite flexible which means it can't > afford to make too many assumptions. Well, it's definitely a bug in PG, it's "quite flexible" type structure notwithstanding. -Neil ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
