From: Bruce Momjian <maillist@candle.pha.pa.us>
To: pierre@desertmoon.com
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] questions on features
Date: Mon, 22 Feb 1999 14:27:16 -0500 (EST)
Message-ID: <199902221927.OAA07321@candle.pha.pa.us> (raw)
In-Reply-To: <19990222144644.13573.qmail@desertmoon.com>
> 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
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: maillist@candle.pha.pa.us, pierre@desertmoon.com
Subject: Re: [SQL] questions on features
In-Reply-To: <199902221927.OAA07321@candle.pha.pa.us>
References: <19990222144644.13573.qmail@desertmoon.com> <199902221927.OAA07321@candle.pha.pa.us>
* 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