Re: sql by length of data

From: Andreas Scherbaum <adsmail(at)htl(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: sql by length of data
Date: 2002-03-20 13:59:44
Message-ID: 3C9895D0.6FF133FE@htl.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Naomi Walker 2002-03-20 15:45:43 Re: pg_dump max file size exceeded
Previous Message Rasmus Mohr 2002-03-20 09:19:32 Failure loading TCL/u