Try length function:
userbase=> select length(cast ('123456' as text));
length
------
6
(1 row)
On Tue, 30 Jun 1998, Trinh Hoai Nhan wrote:
> It am a bit ashamed asking this, but I could not find a pgsql function
> that returns length of a text. Would anybody give me an advice?
>
> Thank you in advance.
> Trinh H. Nhan.
>
>