Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.2/8.9.1) with ESMTP id OAA79555 for ; Mon, 22 Feb 1999 14:38:33 -0500 (EST) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id OAA07321; Mon, 22 Feb 1999 14:27:16 -0500 (EST) From: Bruce Momjian Message-Id: <199902221927.OAA07321@candle.pha.pa.us> Subject: Re: [SQL] questions on features In-Reply-To: <19990222144644.13573.qmail@desertmoon.com> from "pierre@desertmoon.com" at "Feb 22, 1999 7:46:44 am" To: pierre@desertmoon.com Date: Mon, 22 Feb 1999 14:27:16 -0500 (EST) Cc: pgsql-sql@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL47 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > All, > I've just about convinced a friend to rip out an old DB->Web system at their > company and replace it with a linux solution running php and postgres. There > are some issues however. They are running oracle 7.3 on a non-y2k > compliant AIX box, with a non y2k complient front-end cgi. As they are used to > oracle they had some questions about the features of postgres. > > 1) Does postgres support formatting of columns, say in monetary format. That > is using a select, have postgres format the value of the column in dollars, > ect. Yes, define it as money. Even supports foreign stuff, I think. > > 2) Does postgres support the || feature in selectes. That is having a select > look like: select a || '-' || b from fubar; to get output that looks like > 1-2 > 2-3 > 3-4 > ect... Yes, but you have to use parens if you use more than one ||. This is because of the type-extensibility features. select (a || b) || c. > > 3) When will postgres support: select count(distinct(*)) from fubar; ? I > would guess this falls into sub-selects? Not sure. > > 4) Are there any better clients than psql? The psql client is very > unforgiving in that if you mis-type a piece of sql, you cannot tell > psql to abort the current expression.(At least not that I'm aware of) Everyone I heard loves psql. \e lets you edit the query, or up-arrow. > > 5) What about a report generator, does postgres have one? Not sure, but I have heard of some. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026