blackwater dev wrote on 04.02.2009 00:44:
I need to return all rows in a table where one of the columns 'name' is
37+ characters. In postgres, is there a function to get the length of
the columns contents?
Check out char_length()
http://www.postgresql.org/docs/8.3/static/functions-string.htm
On Tue, 2009-02-03 at 18:44 -0500, blackwater dev wrote:
> I need to return all rows in a table where one of the columns 'name'
> is 37+ characters. In postgres, is there a function to get the length
> of the columns contents?
>
http://www.postgresql.org/docs/8.3/static/functions-string.html
len
I need to return all rows in a table where one of the columns 'name' is 37+
characters. In postgres, is there a function to get the length of the
columns contents?
Thanks!