Hi, No, there can be no space after 'any' because the foreign key prevents it (which you of course could not check since I didn't show the content of the foreign table).
But anyway, here is the output: webshop=# select oid,id,'['||locale||']','['||name||']' from content_loc where id=20488 and locale='any'; oid | id | ?column? | ?column? ---------+-------+----------+---------------- 9781056 | 20488 | [any] | [Rise Part II] 9781058 | 20488 | [any] | [Rise Part II] (2 rows) Baldur Quoting Martijn van Oosterhout <[EMAIL PROTECTED]>: > On Tue, Nov 25, 2003 at 12:22:29PM +0100, Baldur Norddahl wrote: > > Hi, > > > > I just noticed something bad in our database: > > > > webshop=# select oid,* from content_loc where id=20488; > > oid | id | locale | name > > ---------+-------+--------+-------------- > > 9781056 | 20488 | any | Rise Part II > > 9781058 | 20488 | any | Rise Part II > > (2 rows) > > Any possibility there are hidden spaces? What is the output of: > > select oid,id,'['||locale||']','['||name||']' from content_loc where > id=20488; > > Hope this helps, > -- > Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > > "All that is needed for the forces of evil to triumph is for enough good > > men to do nothing." - Edmond Burke > > "The penalty good people pay for not being interested in politics is to be > > governed by people worse than themselves." - Plato > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend