Re: truncate column width - Mailing list pgsql-general

From Gregory Wood
Subject Re: truncate column width
Date
Msg-id 000f01c1be07$fdb412d0$7889ffcc@comstock.com
Whole thread Raw
In response to truncate column width  (Hugo Coolens <hugo.coolens@skynet.be>)
List pgsql-general
> Is it possible to truncate the width of certain columns when selecting
> records?

Certainly.

> something like:
> select * from mytable where width of this_column truncated to 30
> characters;

select substr('this_column', 1, 30) as this_column_trunc from mytable;

Greg


pgsql-general by date:

Previous
From: Robert Lummert
Date:
Subject: Re: setting up a trace through extended stored procedures
Next
From: mohan ananthiah
Date:
Subject: Urgnt. - problem starting postgres