Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: print/return only the first X chars of a varchar column?
- From: Adrian Klaver <aklaver(at)comcast(dot)net>
- To: pgsql-general(at)postgresql(dot)org
- Cc: Kevin Kempter <kevink(at)consistentstate(dot)com>
- Subject: Re: print/return only the first X chars of a varchar column?
- Date: Mon, 31 Aug 2009 07:53:08 -0700
- Message-id: <200908310753.09061.aklaver@comcast.net> <text/plain>
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 [from int] [for int]) -- Adrian Klaver aklaver(at)comcast(dot)net
- References:
- print/return only the first X chars of a varchar column?
- From: Kevin Kempter
- print/return only the first X chars of a varchar column?
- Prev by Date: print/return only the first X chars of a varchar column?
- Next by Date: Looking for "proper" escape string syntax from pg_get_constraintdef
- Previous by thread: print/return only the first X chars of a varchar column?
- Next by thread: Looking for "proper" escape string syntax from pg_get_constraintdef
- Indexes: