[GENERAL] memory usage and cache query

2001-04-11 Thread ochapiteau
My process in php submit about 1000 querys (in a while) like : "INSERT INTO table SELECT id from table2 where ..." This type of query for me does'nt require any memory in the php process (all to postgres process) is use pg_exec and pg_freeresult just after each query call. But when this script ru

[GENERAL] Re: to_date & to_char with postgres 6.5 & 7.0

2001-02-28 Thread ochapiteau
> > On Wed, Feb 28, 2001 at 10:28:11AM +0100, ochapiteau wrote: > > I have a database in production under 6.5 and i need to use the to_date and > > to_char function. > > I planned to migrate to postgres 7.0 later but i need a compatibility from now > > for my

[GENERAL] to_date & to_char with postgres 6.5 & 7.0

2001-02-28 Thread ochapiteau
I have a database in production under 6.5 and i need to use the to_date and to_char function. I planned to migrate to postgres 7.0 later but i need a compatibility from now for my projects. Where do i find the postgres65.sql to install this functions under postgres 65 ? thanks, oliver