pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
questions on features
3+ messages / 3 participants
[nested] [flat]

* questions on features
@ 1999-02-22 14:46  pierre@desertmoon.com
  0 siblings, 1 reply; 3+ messages in thread

From: pierre@desertmoon.com @ 1999-02-22 14:46 UTC (permalink / raw)
  To: pgsql-sql

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.

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

  3) When will postgres support: select count(distinct(*)) from fubar; ? I
  would guess this falls into sub-selects?

  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)

  5) What about a report generator, does postgres have one?

  Thanks for your help!

  -=pierre



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [SQL] questions on features
@ 1999-02-22 19:27  Bruce Momjian <maillist@candle.pha.pa.us>
  parent: pierre@desertmoon.com
  0 siblings, 0 replies; 3+ messages in thread

From: Bruce Momjian @ 1999-02-22 19:27 UTC (permalink / raw)
  To: pierre@desertmoon.com; +Cc: pgsql-sql

> 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [SQL] questions on features
@ 1999-02-22 22:43  Dave Inskeep <dinskeep@yahoo.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Dave Inskeep @ 1999-02-22 22:43 UTC (permalink / raw)
  To: Bruce Momjian <maillist@candle.pha.pa.us>; pgsql-sql


---Bruce Momjian <maillist@candle.pha.pa.us> wrote:

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

Not sure that I would agree with this 100%... but for those who don't
like psql, there is mpsql, which is a Motif psql client.  I don't
remember the site, but you can find it searching the apps and lsm from
www.linux.org.

Dave Inskeep
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~1999-02-22 22:43 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-02-22 14:46 questions on features pierre@desertmoon.com
1999-02-22 19:27 ` Bruce Momjian <maillist@candle.pha.pa.us>
1999-02-22 22:43 Re: [SQL] questions on features Dave Inskeep <dinskeep@yahoo.com>

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