function on trigger - Mailing list pgsql-general

From Marcos Hercules Santos
Subject function on trigger
Date
Msg-id b3ba2b32-278f-4216-9de3-39ab2162fc23@y21g2000yqy.googlegroups.com
Whole thread Raw
Responses Re: function on trigger  (David Johnston <polobo@yahoo.com>)
Re: function on trigger  (John R Pierce <pierce@hogranch.com>)
Re: function on trigger  (Sim Zacks <sim@compulab.co.il>)
List pgsql-general
hi guys

I'm newbie in Psql and I'm trying to build one function  in order to
count the products for each supplier. So i'm gonna put it quite simply
though this example


Please, consider a table called books with the following fields

bookid, title, price, idPublisher



and one another table called publisher

Idpublisher, name, city, Books


Being in that last field from Publisher, called book, I gotta have the
amount of published books for each publisher.

pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Re: ARRAY_AGG(DISTINCT a ORDER BY b) Error
Next
From: David Johnston
Date:
Subject: Re: function on trigger