"Brian" <[EMAIL PROTECTED]> writes:
> The same join here, updates every row in the table which is incorrect.
> update
>dw.prints_by_hour
> set
>count = h.count + w.count
> from
>dw.prints_by_hour_work w , dw.prints_by_hour h
> WHERE
> w.year = h.year
>
This WHERE clause finds a single row that has the
same year,month,day,hour in another table.
It correctly counts 1 row.
SELECT count(*)
FROM dw.prints_by_hour_work w ,
dw.prints_by_hour
hWHERE
w.year = h.year
and w.month = h.month and
w.day = h.day
Is the following link removed?
http://pgfoundry.org/download.php/59/postgresql-8.0-beta1-20040809.msi
When connected through the firewall i get
"Zero Sized Reply" error message. Trying to download when connected directly
through modem it just blinks the screen and nothing happens. (Tryed bo
Hi pgsql-bugs,
I'm a Chinese and I am using WinXp Chs to compile pgsql 8.0 beta 1
in the MinGW environment. I found 2 bugs and fix them, maybe you can
merge the patch into the offical release, thanks.
Part A) Below is the two bugs occur when we run initdb under WinXp Chs.
1) FATAL: syn
On Friday 27 August 2004 20:21, Tom Lane wrote:
> Steve Ingram <[EMAIL PROTECTED]> writes:
> > When I pg_dump out the database, it outputs all the tables, functions,
> > types as you'd expect, but it outputs table definitions that reference
> > postgis functions/types *before* the functions/types t
