X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9012DD1E137 for ; Fri, 20 Feb 2004 14:26:22 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 91532-04 for ; Fri, 20 Feb 2004 10:26:22 -0400 (AST) Received: from php.gurugeek.org (unknown [213.174.166.198]) by svr1.postgresql.org (Postfix) with ESMTP id 3889BD1E14D for ; Fri, 20 Feb 2004 10:26:02 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by php.gurugeek.org (Postfix) with ESMTP id 233691F04CE; Fri, 20 Feb 2004 15:26:05 +0100 (CET) In-Reply-To: <20040219204310.97623.qmail@web40010.mail.yahoo.com> References: <20040219204310.97623.qmail@web40010.mail.yahoo.com> Mime-Version: 1.0 (Apple Message framework v609) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: Content-Transfer-Encoding: 7bit Cc: PostgreSQL WWW Mailing List From: David Costa Subject: Re: Feeds Integration Date: Fri, 20 Feb 2004 15:26:03 +0100 To: Chris Ryan X-Mailer: Apple Mail (2.609) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/149 X-Sequence-Number: 3714 On Feb 19, 2004, at 9:43 PM, Chris Ryan wrote: > If you provide a script I can work through any specific issues > during implementation. > Okay I will email you directly re: implementation :D > Chris Ryan > > --- David Costa wrote: >>> >>> Here is an updated query. The URL had slipped my mind as one I >>> build the URLs from knows practices on GBorg and the body is >> actually >>> the full story. You'll note as well in the query below that I added >> in >>> for getting the submitter of the news item. >>> >>> SELECT headline AS title, >>> >>> 'http://gborg.postgresql.org/project/'||project_name||'/news/ >>> newsfull.php?news_id='||news_id >>> AS link, -- the fully built url to the news item >>> body, -- the full news text you may want to abbreviate >> here >>> member_name AS author, -- member name on gborg of author >>> submit_date -- date not datetime :( >>> FROM project_news, project, member >>> WHERE (project_news.project_id=project.project_id) >>> AND (project_news.member_id=member.member_id) >>> AND (project_news.active=true) >>> AND (project_news.on_homepage=true) >>> ORDER BY submit_date DESC >>> LIMIT 10; >>> >> >> Okay. I will need a sample db table table if you want me to test it. >> >> Else I don't physically have where to run the query :D >> >> Or perhaps I do the script, leave it on my webspace and let you/Marc >> or >> Dave to try this out. That would work for me, I don't really need any >> >> further access. Without the db I can >> still do the script ready to run but I cannot test if the query >> returns >> what we would expect or not. >> >> Thanks again for your support, >> cheers >> David Costa >> >>> >>> >>> Chris Ryan >>> >>> >>> __________________________________ >>> Do you Yahoo!? >>> Yahoo! Mail SpamGuard - Read only the mail you want. >>> http://antispam.yahoo.com/tools >> >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 4: Don't 'kill -9' the postmaster > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail SpamGuard - Read only the mail you want. > http://antispam.yahoo.com/tools