Limiting character count

From: "roy simkes" <roysimkes(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Limiting character count
Date: 2006-07-26 08:47:10
Message-ID: BAY108-W342BC006ACE1B883135FDA15B0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,I'm have a field which allows maximum 1000 characters. But when I fecth it I only want to show first 50 characters and then give a link to see the whole data. Is there a way to do this easily with postgresql or I should do this using php functions and other logic things.I hope I was clear enough I should show something like this:Hi, I'm new in town and I'm a little bit lost can yo... (more)Where the whole text is :Hi I'm new in town and I'm a little bit lost can you show me where is Mr Brown's house?
_________________________________________________________________
Try Live.com: where your online world comes together - with news, sports, weather, and much more.
http://www.live.com/getstarted

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Christoph Frick 2006-07-26 09:09:38 Re: Limiting character count
Previous Message Shoaib Mir 2006-07-26 07:52:14 Re: createdb