Re: does this require a stored procedure?

--- Alex Rice <alrice(at)ARCplanning(dot)com> wrote:
> Is it possible to rewrite this SQL query so it returns one row having
> the columns title and contentType, instead of two rows with the sname
> column?
>
> # SELECT rec_id, url, sname, sval FROM url, urlinfo
> WHERE url.rec_id = 1821
> AND url.rec_id = urlinfo.url_id
> AND sname in('title','Content-Type');
>
> rec_id | url | sname | sval
> -------+--------------
> +---------------------------------------------------------
> 1821 | http://.../ | title | Architectural Research
> Consultants, Incorporated Contact Information
> 1821 | http://.../ | Content-Type | text/html
> (2 rows)
>
> mnogosearch=> \d urlinfo
> Table "public.urlinfo"
> Column | Type | Modifiers
> --------+---------+-----------
> url_id | integer | not null
> sname | text | not null
> sval | text | not null
> Indexes: urlinfo_id btree (url_id)
>
> Thanks,
> Alex Rice, Software Developer
> Architectural Research Consultants, Inc.
> alrice(at)ARCplanning(dot)com
> alrice(at)swcp(dot)com

do you mean something like:

select t.url_id, t.url as title_url, t.sval as title_val,
c.url as content_url, c.sval as content_val
from
(select * from urlinfo where sname = 'title') t
join
(select * from urlinfo where sname = 'Content-type') c
using( url_id );

__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com