From: Alex Rice <alrice@ARCplanning.com>
To: pgsql-sql@postgresql.org
Subject: does this require a stored procedure?
Date: Thu, 8 May 2003 12:50:02 -0600
Message-ID: <E01C567E-8185-11D7-A998-000393529642@ARCplanning.com> (raw)
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? I could write a stored procedure to lookup the title or
content-type based on the rec_id, but I would rather do it in a single
query if it's possible.
# 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@ARCplanning.com
alrice@swcp.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: alrice@ARCplanning.com
Subject: Re: does this require a stored procedure?
In-Reply-To: <E01C567E-8185-11D7-A998-000393529642@ARCplanning.com>
References: <E01C567E-8185-11D7-A998-000393529642@ARCplanning.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox