On Friday 04 Oct 2002 5:35 pm, ¼B¤tºÆ wrote:
> Hi all,
> I have two table, follow :
>
> content
> content_id | material_id | percentage
> -----------------------------------------------------
> 1 1 100%
> 2 2 63.5%
> 2 3 31.5%
> 2 4 5%
>
> material
> material_id | name
> ------------------------------------------
> 1 COTTON
> 2 POLYESTER
> 3 NYLON
> 4 SPANDEX
>
> The Question is,
> How can I get like this :
> 100% COTTON
> 63.5% POLYESTER 31.5% NYLON 5% SPANDEX
>
> Can I return the string like this ?
Not using SQL - you could define a function: material_names(int4) returning
text - provide it the "content_id" and it does the lookup and builds the
string required. You could do this with plpgsql, it's a simple language but
make sure you read the manual first. You could also use tcl/perl/c - see the
procedural languages chapter for details.
The other option is to do this in the client application.
- Richard Huxton