Hi all!
I want to do something like this:
SELECT status, COUNT( status ) AS total
FROM users
GROUP BY status
UNION
SELECT status, COUNT(status) AS total
FROM imported_users
GROUP BY status
And have the result of both added.
I've tried something like
SELECT tot.status, COUNT(total)
FROM( QU
Στις Δευτέρα 16 Ιούλιος 2007 14:06, ο/η Dani Castaños έγραψε:
> Hi all!
>
> I want to do something like this:
>
> SELECT status, COUNT( status ) AS total
> FROM users
> GROUP BY status
>
> UNION
>
> SELECT status, COUNT(status) AS total
> FROM imported_users
> GROUP BY status
>
>
> And have the res
Dani Castaños escreveu:
...
And have the result of both added.
I've tried something like
SELECT tot.status, COUNT(total)
Should be
SELECT tot.status, SUM(total)
FROM( QUERY A UNION QUERY B ) AS tot
GROUP BY tot.status
But it doesn't works. It doesn't add the total columns with the same
s
Good day, Jyoti.
JS> I want to call webservice from my postgresql database. Please let me know
if anyone has idea.
Idia or proper tool?
If idea, I offer to append some code into source of pg.
I already raised this question in topic
"We all are looped on Internet",
in which i read, that the most
... SELECT tot.status, COUNT(total)
FROM( QUERY A UNION QUERY B ) AS tot
GROUP BY tot.status
But it doesn't works. It doesn't add the total columns with the same
status...
...
I guess you have two problems, if I understand what you're trying to do.
- As Roberto Spier noted, 'sum' would be be
Hello Dmity,
As suggested by Richard Huxton in this forum we can use any of the
"untrusted" procedural languages to access resources outside the database
(e.g. pl/perlu).
You can get the code to call the webservice from the postgresql function
from this url. http://www.pgsql.cz/index.php/PL/Perlu
