Dumb question, but is id actually defined as the primary key constraint
in the table definition?
~Berend Tober
> 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 <kleptog@svana.org>:
>
>> 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;
>>
