chapters 15 / 24 of the excellent documentation about running both
8.1 and 9.04 at the same time and migrating a database at a time.
So, I suppose unless there is something obvious, (to someone else) - we have
all the information we need.
Gavin Beau Baumanis
On 17/05/2011, at 9:04 AM, Gavin
Hi there,
Let me first preface this with, I am not a PostgreSQL admin.
I am a web developer who happens to use PSQL as the back-end for my company's
app.
We did have a dedicated DBA / system admin - but he has recently resigned.
I know enough about psql - to be able to create / drop databases...
At the risk of being wrong (I'm always ready to learn something
new) - and seemingly I'm only too happy to be wrong!...
And... it might even be that it is exactly the same result - but I
would have proposed;
SELECT
R.region_name,
Count(*) AS RegionComplaints
FROM
Region AS
Hi Everyone,
Sorry if I am missing something obvious but I think I have found a bug.
If I perform the following SQL
SELECT MAX(column) FROM table WHERE expression
and there is no match, Postgres returns a record count of 1.
There is no value in max, it is NULL.
Thus trying to perform some