On 10/05/2004 22:30 Rory Campbell-Lange wrote:
Sorry for replying to my own post, but I'm anxious for an answer. Should I provide other information?
Look carefully at your column types. I can see several smallint columns in there WHERE clause which are not expicitely typed as such.
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for Business |
| Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly