Re: [ADMIN] Help with simple function

2005-12-28 Thread Chris Hoover
On 12/28/05, Jason Minion <[EMAIL PROTECTED]> wrote: And last but not least, you can do simple day addition and subtractionwith dates using integers. For example:> select '2005-12-26'::date + 8;returns '2006-01-03'. However, I'm not sure if that will work with 7.3.x. Good luck with your 8.x install

Re: [ADMIN] Help with simple function

2005-12-28 Thread Jason Minion
Behalf Of Chris Hoover Sent: Wednesday, December 28, 2005 8:49 AM To: pgsql-admin@postgresql.org Subject: [SPAM] - [ADMIN] Help with simple function - Bayesian Filter detected spam I need some help. I am trying to get a very simple function written to help our developers. Unfortunetly, the langu

[ADMIN] Help with simple function

2005-12-28 Thread Chris Hoover
I need some help.  I am trying to get a very simple function written to help our developers.  Unfortunetly, the language we are developing in is giving us some grief over trying to do a "select to_char((current_date - inteval '1 day'),'mmdd') into x".  It is complaining about the use of the wor