Re: UDD contains names where spaces are not stripped

2023-12-07 Thread Lucas Nussbaum
On 07/12/23 at 20:24 +0100, Andreas Tille wrote: > Am Thu, Dec 07, 2023 at 07:59:38PM +0100 schrieb Lucas Nussbaum: > > On 07/12/23 at 09:58 +0100, Andreas Tille wrote: > > > Hi, > > > > > > by chance I realised that the uploaders table contains some names where > > > names > > > are not stripped

Re: UDD contains names where spaces are not stripped

2023-12-07 Thread Andreas Tille
Am Thu, Dec 07, 2023 at 07:59:38PM +0100 schrieb Lucas Nussbaum: > On 07/12/23 at 09:58 +0100, Andreas Tille wrote: > > Hi, > > > > by chance I realised that the uploaders table contains some names where > > names > > are not stripped: > > > > udd=> select '"' || u.name || '"' as name_with_space

Re: UDD contains names where spaces are not stripped

2023-12-07 Thread Lucas Nussbaum
On 07/12/23 at 09:58 +0100, Andreas Tille wrote: > Hi, > > by chance I realised that the uploaders table contains some names where names > are not stripped: > > udd=> select '"' || u.name || '"' as name_with_spaces, uploader from > uploaders u where name like '% ' or name like ' %' ; > name