pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (3+ messages)  latest in thread

Message-ID: <199902221927.OAA07321@candle.pha.pa.us>
Permalink:  ../199902221927.OAA07321@candle.pha.pa.us/
Also on:    postgresql.org/message-id/199902221927.OAA07321@candle.pha.pa.us

 · 

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: 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