Обсуждение: sql by length of data

select a, b, c where length(a=2);

How do you do this?  I couldn't find a postgres command for this kind of
call.

Thanks

Kristopher Yates wrote:
>
> select a, b, c where length(a=2);
>
> How do you do this?  I couldn't find a postgres command for this kind of
> call.

SELECT a, b, c FROM table WHERE LENGTH(a) = 2;


best regards

--
                                  Andreas 'ads' Scherbaum