Forum OpenACS Q&A: Re: postgresql syntax

Collapse
9: Re: postgresql syntax (response to 1)
Posted by Brad Ford on
Thanks all!

Seems my efforts to cast to interval were the right direction, just screwed
up the syntax - the docs make it look like it should be + interval('14
days') where it has to be just interval '14 days' or '14 days'::interval, latter method preferred I take it?

Following through to the patch in the above link, it seems that at least the
first bug was already fixed for news. But the bug in the above patch isn't
in the news package section of bug tracker - is there much duplication
within bug tracker i.e. might the other news package bugs already be fixed
elsewhere?

Also, once I make changes on my site in the package contents like the xql
files, do I need to restart the server to see them? i.e. are all the xql
files for active packages cached on startup?

Once I get everything fixed up with news (and I'm sure it will involve a bunch more postings...), I'll talk to Don about committing them.