Re: [GENERAL] print/return only the first X chars of a varchar column?

the first X chars of a varchar column? 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 -- Sent via pgsql-general mailing list

[GENERAL] print/return only the first X chars of a varchar column?

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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] print/return only the first X chars of a varchar column?

On Monday 31 August 2009 7:49:12 am Kevin Kempter wrote: 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 substring(string