Re: table linking problem

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