Radicore Forum: RADICORE Installation Issues » Problem using PostgreSQL 9.1

Home » RADICORE » RADICORE Installation Issues » Problem using PostgreSQL 9.1

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Problem using PostgreSQL 9.1 [message #2849 is a reply to message #2847]

Thu, 15 December 2011 04:30

AJM
Messages: 2368
Registered: April 2006
Location: Surrey, UK

Senior Member

This is not actually a platform issue, but converting a query that works in MySQL to one that works in PostgreSQL. In this case my code (which was written primarily for MySQL) generates a query containing:

DATE_SUB(due_date, INTERVAL visibility DAY)

Inside dml.pgsql.class.inc this is converted to:

DATE_SUB(due_date::timestamp, (visibility * INTERVAL '1 day')::interval)

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		Problem using PostgreSQL 9.1 By: roderickm on Tue, 13 December 2011 09:14
		Re: Problem using PostgreSQL 9.1 By: AJM on Tue, 13 December 2011 15:48
		Re: Problem using PostgreSQL 9.1 By: AJM on Wed, 14 December 2011 04:30
		Re: Problem using PostgreSQL 9.1 By: roderickm on Wed, 14 December 2011 09:20
		Re: Problem using PostgreSQL 9.1 By: AJM on Wed, 14 December 2011 12:15
		Re: Problem using PostgreSQL 9.1 By: roderickm on Thu, 15 December 2011 03:16
		Re: Problem using PostgreSQL 9.1 By: smithcharles on Thu, 15 December 2011 00:16
		Re: Problem using PostgreSQL 9.1 By: AJM on Thu, 15 December 2011 04:30
		Re: Problem using PostgreSQL 9.1 By: kong on Tue, 20 March 2012 11:31
		Re: Problem using PostgreSQL 9.1 By: AJM on Tue, 20 March 2012 14:29

Previous Topic:	Login Error
Next Topic:	Class 'radicore_view' not found

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Nov 24 17:04:59 EST 2024

Total time taken to generate the page: 0.01001 seconds