Prev: Problem with pg_prepare - PostgresSQL
Next: Any good explanations of pg_send_execute and friends?
From: "Ron Piggott" on 24 Apr 2010 20:50
I am received the error message:

Unknown column 'title' in 'field list'

from the query below. I am not understanding what I have done wrong. The
goal of the query is with for a RSS feed determining the 15 most current
articles.

Ron



SELECT title, content_date, content, reference FROM ( (

SELECT `page_title`, `last_update`, 'article', `reference` FROM
`user_pages` WHERE `include_in_highlights` =1 ORDER BY `last_update` DESC
LIMIT 15

) UNION ALL (

SELECT `blog`.`entry_title`, `blog`.`entry_date`, `blog`.`entry`,
`blog`.`reference` FROM blog WHERE blog_owners_reference =1 ORDER BY
blog.entry_date DESC, blog.reference DESC LIMIT 15

) ) AS rss_feed ORDER BY rss_feed.content_date DESC LIMIT 15

From: Ron Piggott on 24 Apr 2010 18:17
Ok. I have received help and got it fixed. I didn't have the variables
matching the first query. I haven't done a UNION ALL recently. Thanks.
Ron
From: maarten on 26 Apr 2010 03:48
Your union creates a table called rss_feed. This table has 4 columns
(page_title, last_update, article and reference) from which you try to
select the unknown column 'title'.

So basicly, exactly what your db is telling you.
If it doesn't make sense, strip the outer select and see what your
subquery returns. That should make it more clear.

regards




On Sat, 2010-04-24 at 20:50 -0400, Ron Piggott wrote:
> I am received the error message:
>
> Unknown column 'title' in 'field list'
>
> from the query below. I am not understanding what I have done wrong. The
> goal of the query is with for a RSS feed determining the 15 most current
> articles.
>
> Ron
>
>
>
> SELECT title, content_date, content, reference FROM ( (
>
> SELECT `page_title`, `last_update`, 'article', `reference` FROM
> `user_pages` WHERE `include_in_highlights` =1 ORDER BY `last_update` DESC
> LIMIT 15
>
> ) UNION ALL (
>
> SELECT `blog`.`entry_title`, `blog`.`entry_date`, `blog`.`entry`,
> `blog`.`reference` FROM blog WHERE blog_owners_reference =1 ORDER BY
> blog.entry_date DESC, blog.reference DESC LIMIT 15
>
> ) ) AS rss_feed ORDER BY rss_feed.content_date DESC LIMIT 15
>
>

 | 
Pages: 1
Prev: Problem with pg_prepare - PostgresSQL
Next: Any good explanations of pg_send_execute and friends?