From: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
---|---|
To: | Ziobudda <michel(at)michel(dot)enter(dot)it> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | RE: [GENERAL] question 3 |
Date: | 1998-12-04 23:18:26 |
Message-ID: | F10BB1FAF801D111829B0060971D839F5506CD@cpsmail |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> -----Original Message-----
> From: ZioBudda [SMTP:michel(at)michel(dot)enter(dot)it]
> Sent: Friday, December 04, 1998 4:44 PM
> To: Jackson, DeJuan
> Cc: pgsql-general(at)postgreSQL(dot)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(at)michel(dot)enter(dot)it - http://ziobudda.enter.it/
> Linux Problem? Ask to linux(at)media(dot)dsi(dot)unimi(dot)it
> "/dev/ziobudda: access to /var/tmp/beer denied, use
> /var/adm/pineapple"
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jetzrael Lopez | 1998-12-04 23:43:01 | I Can't to connect From Windows 98 |
Previous Message | Bruce Momjian | 1998-12-04 23:13:38 | Re: [GENERAL] 6.4 ? |