Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
print/return only the first X chars of a varchar column?
- From: Kevin Kempter <kevink(at)consistentstate(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: print/return only the first X chars of a varchar column?
- Date: Mon, 31 Aug 2009 08:49:12 -0600
- Message-id: <200908310849.12852.kevink@consistentstate.com> <text/plain>
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
- Follow-Ups:
- Re: print/return only the first X chars of a varchar column?
- From: Adrian Klaver
- Re: print/return only the first X chars of a varchar column?
- Prev by Date: Re: Query and the number of row result
- Next by Date: Re: print/return only the first X chars of a varchar column?
- Previous by thread: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.
- Next by thread: Re: print/return only the first X chars of a varchar column?
- Indexes: