Thread: RE: [GENERAL] question 3

RE: [GENERAL] question 3

From
"Jackson, DeJuan"
Date:

> -----Original Message-----
> From:    ZioBudda [SMTP:michel@michel.enter.it]
> Sent:    Friday, December 04, 1998 4:44 PM
> To:    Jackson, DeJuan
> Cc:    pgsql-general@postgreSQL.org
> Subject:    RE: [GENERAL] question 3
>
> On Fri, 4 Dec 1998, Jackson, DeJuan wrote:
>
> > I really have no idea what you are truly asking for here, but here's
> a
> > crack at what I think you want.
> >  select count(p.*) from prestito p, libro l
> >  where p.id_libro = l.id_libro
> >  group by p.id_utente, l.tipo
> > Try it...
>
> parser: parse error at or near "*"
sub the * with any column from p this is not NULL.


> "Il divertimento e' giusto se la scimmia ci prende gusto"
> --
> Italian Linux Press: http://ziobudda.enter.it/ILP/
> --
> Morelli 'ZioBudda' Davide Michel - Member of Pluto Linux User Group
> michel@michel.enter.it - http://ziobudda.enter.it/
> Linux Problem? Ask to linux@media.dsi.unimi.it
> "/dev/ziobudda: access to /var/tmp/beer denied, use
> /var/adm/pineapple"
>