pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Thomas Good <tomg@admin.nrnet.org>
To: Herouth Maoz <herouth@oumail.openu.ac.il>
Cc: PostgreSQL::SQL List <pgsql-sql@postgreSQL.org>
Subject: Re: [SQL] DISTINCT count(*), possible?
Date: Sun, 20 Jun 1999 08:47:00 -0400 (EDT)
Message-ID: <Pine.LNX.3.96.990620083348.31117A-100000@admin.nrnet.org> (raw)
In-Reply-To: <l03130303b392837887c2@[147.233.159.109]>

On Sun, 20 Jun 1999, Herouth Maoz wrote:

> > Out of curiosity, more than anything else.
> > Would the group by solve this problem?
> 
> No. What you need is the number of groups, not the number of members in
> each group, which is what group by provides.
> 
> Herouth

Good morning Herouth,

I missed the earlier post(s) on this thread (scrambling to meet
a 01 July go-live date) but the subj caught my eye today as just
yesterday I tried to force 6.3.2 to do a select count(distinct id)
and was rebuffed!

Does this work in 6.5.x?

Also - is there a pg way to do an oracle nvl() type assignment of a 
char str to a NULL value during a query (e.g., 'unmarried');

Finally, I have a annoyance.  My predecessor apparently was unaware or
distrustful of the text data type.  Instead he did this:

                     note_id int4
                     line_no int4
                     noteline char(65)

The user enters lines of text, they are numbered and assigned the (same)
note_id which links them to one note.  Doing a select they are reassembled
into one note.  (I prefer the text data type as I'm not fond of extra
typing... ;-)

Now, I am porting this old PROGRESS db to Postgres and I need to concat
these char strs into a text attribute.  First I dumped and reloaded,
changing the attr holding each str from char() to text.  Now I am clumsily
trying to use the concat operator to select into the new table.

INSERT INTO assessment (assets, debits) 
SELECT asset1 || asset2 AS assets, debit1 || debit2 AS debits
FROM oldtab
WHERE id = xyz AND date = '04-01-1999';

Sometimes it works and mostly it doesn't.
Would you know of a better approach?

Many thanks,
Tom

------- North Richmond Community Mental Health Center -------

Thomas Good                       MIS Coordinator, Senior DBA
Vital Signs:                  tomg@ { admin | q8 } .nrnet.org
                                          Phone: 718-354-5528  
                                          Fax:   718-354-5056  
                              
/* Member: Computer Professionals For Social Responsibility */ 




view thread (8+ messages)

Message-ID: <Pine.LNX.3.96.990620083348.31117A-100000@admin.nrnet.org>
Permalink:  ../Pine.LNX.3.96.990620083348.31117A-100000@admin.nrnet.org/
Also on:    postgresql.org/message-id/Pine.LNX.3.96.990620083348.31117A-100000@admin.nrnet.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: tomg@admin.nrnet.org, herouth@oumail.openu.ac.il
  Subject: Re: [SQL] DISTINCT count(*), possible?
  In-Reply-To: <Pine.LNX.3.96.990620083348.31117A-100000@admin.nrnet.org>
  References: <l03130303b392837887c2@[147.233.159.109]> <Pine.LNX.3.96.990620083348.31117A-100000@admin.nrnet.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox