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
... 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
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
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
Στις Δευτέρα 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
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
