I'd like to know what's the correct SQL statement to do the following:
update t1 a
set a.amount = sum(b.amount)
fromt2 b
where a.id = b.id
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
&g
I have a Borland C++ program (running on NT server) which connects to
PostgresSQL (V6.5) via ODBC (V6.5). The program reads data file and
updates database at regular intervals. The program has close all
connections when execution finishes.
This program seems to use a lot of the memory on the lin
Hi All
I'm using V6.5.
I need to use the dd/mm/yy format, but the database seems to interpret
it as mm/dd/yy, unless the digig >12, then the date format is
interpreted as dd/mm/yy. Are there any setting required?