Re: [SQL] Date problem

2000-09-28 Thread Tom Lane
>> Ok. Let's work. I posted a mail before explaining a strange >> cituation if my Postgresql: when I use date_part() function to split >> day, month and year of a date type column, it returns one day before. >> In other words, '2000-01-01' returns day: 31, month:12, year: 1999. > No problem here.

Re: [SQL] Date problem

2000-09-28 Thread Josh Berkus
Elipo, > Ok. Let's work. I posted a mail before explaining a strange > cituation if my Postgresql: when I use date_part() function to split > day, month and year of a date type column, it returns one day before. > In other words, '2000-01-01' returns day: 31, month:12, year: 1999.

[SQL] Date problem

2000-09-28 Thread Edipo E. F. Melo
Hi all, Hi all, Before all, a little (off-topic) comment: >It's been my experience that Win32 ODBC does not drop >connections until the database client is closed (e.g. MS >Access is shut down). "There is some things that only Micro$oft can do for you..." Ok. Let's wor

Re: [SQL] memory usage

2000-09-28 Thread Carolyn Wong
John Hasler wrote: > > Carolyn Wong writes: > > This program seems to use a lot of the memory on the linux server, and > > the memory doesn't seem to be released at the end of execution. > > Are you quite certain that this is actually what is happening? Linux > memory usage can be confusing.

Re: [SQL] transactions surrounding extension functions

2000-09-28 Thread Peter Eisentraut
Forest Wilkinson writes: > Does this mean that when I call a function I wrote, which is composed > of several queries, each of those queries will be executed in its own > transaction? No > Or, will the statement containing the function call be executed in its > own transaction, thereby includin

[SQL] transactions surrounding extension functions

2000-09-28 Thread Forest Wilkinson
According to the postgres 7 docs: >By default, Postgres executes transactions in unchained mode (also >known as “autocommit” in other database systems). In other words, each >user statement is executed in its own transaction and a commit is >implicitly performed at the end of the statement (if

Re: [SQL] memory usage

2000-09-28 Thread John Hasler
Carolyn Wong writes: > This program seems to use a lot of the memory on the linux server, and > the memory doesn't seem to be released at the end of execution. Are you quite certain that this is actually what is happening? Linux memory usage can be confusing. -- John Hasler [EMAIL PROTECTED] (J