Re: [BUGS] Implicit cast of literal in SQL statements

2001-12-27 Thread Scott Royston
I've got some 'legacy' code that I'm dealing with - sometimes it will receive query requests that are simply the union of two easier requests it already knows the sql for. These 'easier' queries have 'distincts' in them, and the code doesn't go to the trouble of removing by hand when doing a un

[BUGS] Implicit cast of literal in SQL statements

2001-12-27 Thread Scott Royston
I've seen a few postings in multiple newsgroups saying that in 7.1.x and up, literals in SQL statements are implicitly cast to strings. For example in: select distinct 'hello' from mytable; the 'hello' is implicitly assumed to be 'hello'::text However, in both 7.1.3, and a fresh build of 7.2b4