Re: [ADMIN] sql by length of data

[Andreas Scherbaum]

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html