Postgres Pro
Downloads
Home   >   mailing lists

Re: Looks are important - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Looks are important
Date
Msg-id 200311121556.12887.josh@agliodbs.com
Whole thread Raw
In response to Looks are important  ("George Weaver" <georgew1@mts.net>)
List pgsql-sql
Tree view 
George,

> SELECT RPAD(no,30,' ') || tableb.kind FROM tablea
> WHERE tablea.kind = tableb.kind

Try SELECT RPAD(no, (35 - LENGTH(tableb.kind)), ' ')

--
-Josh BerkusAglio Database SolutionsSan Francisco

pgsql-sql by date:

Previous
From: "George Weaver"
Date:
Subject: Looks are important
Next
From: "Louise Cofield"
Date:
Subject: Re: Looks are important