Postgres Pro
Downloads
Home   >   mailing lists

print/return only the first X chars of a varchar column? - Mailing list pgsql-general

From Kevin Kempter
Subject print/return only the first X chars of a varchar column?
Date
Msg-id 200908310849.12852.kevink@consistentstate.com
Whole thread Raw
Responses Re: print/return only the first X chars of a varchar column?
Re: print/return only the first X chars of a varchar column?
List pgsql-general
Tree view 
Hi all;

I'm selecting from a table that has a varchar(1000) but I only want to display
the firs 20 characters.  Looked at the string functions in the docs but nothing
jumped out...

Suggestions?


Thanks in advance

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Query and the number of row result
Next
From: Adrian Klaver
Date:
Subject: Re: print/return only the first X chars of a varchar column?