Postgres Pro
Downloads
Home   >   mailing lists

Re: sql by length of data - Mailing list pgsql-admin

From Andreas Scherbaum
Subject Re: sql by length of data
Date
Msg-id 3C9895D0.6FF133FE@htl.de
Whole thread Raw
In response to sql by length of data  ("Kristopher Yates" <kris@grinz.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Dmitry Tkach
Date:
Subject: Btree index extension question
Next
From: Naomi Walker
Date:
Subject: Re: pg_dump max file size exceeded