public inbox for [email protected]  

help / color / mirror / Atom feed

Moving to PostGres
3+ messages / 3 participants
[nested] [flat]

* Moving to PostGres
@ 2002-10-07 02:00 Benjamin Stewart <[email protected]>
  2002-10-07 02:37 ` Re: Moving to PostGres [email protected]
  2002-10-07 16:18 ` Re: Moving to PostGres Neil Conway <[email protected]>
  0 siblings, 2 replies; 3+ messages in thread

From: Benjamin Stewart @ 2002-10-07 02:00 UTC (permalink / raw)
  To: [email protected]; pgsql-docs

Hello,
I am looking at moving our company away from MS SQL. Have been looking at
DB2 and it looks to have some good features. Now wondering if POSTGRESQL
could be a viable alternative. I have a few questions though;
1. What is the postgresql equiv to Stored procedures and can they be written
in another langauage such s JAVA?
2. How well is JAva supported for developing DB applications using PG?
3. What are the limitations to PG compared to DB2, Oracle, Sybase ?

Thanks
Ben





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

* Re: Moving to PostGres
  2002-10-07 02:00 Moving to PostGres Benjamin Stewart <[email protected]>
@ 2002-10-07 02:37 ` [email protected]
  1 sibling, 0 replies; 3+ messages in thread

From: [email protected] @ 2002-10-07 02:37 UTC (permalink / raw)
  To: [email protected]; pgsql-docs

In article <[email protected]>,
Benjamin Stewart <[email protected]> wrote:

>I am looking at moving our company away from MS SQL.


Here's a good place to start:

  http://techdocs.postgresql.org/redir.php?link=/techdocs/sqlserver2pgsql.php

--
http://www.spinics.net/linux/



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

* Re: Moving to PostGres
  2002-10-07 02:00 Moving to PostGres Benjamin Stewart <[email protected]>
@ 2002-10-07 16:18 ` Neil Conway <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: Neil Conway @ 2002-10-07 16:18 UTC (permalink / raw)
  To: Benjamin Stewart <[email protected]>; +Cc: [email protected]

"Benjamin Stewart" <[email protected]> writes:
> 1. What is the postgresql equiv to Stored procedures and can they be written
> in another langauage such s JAVA?

PostgreSQL supports user-defined functions; in 7.3 (currently in beta)
they can return sets of tuples.

You can define functions in Java using http://pljava.sf.net , or in a
variety of other languages (Perl, Python, Tcl, Ruby, C, PL/PgSQL, SQL,
sh, etc.)

> 2. How well is JAva supported for developing DB applications using
>    PG?

"Pretty well", I guess. If you have a specific question, ask it.

Cheers,

Neil

-- 
Neil Conway <[email protected]> || PGP Key ID: DB3C29FC





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

end of thread, other threads:[~2002-10-07 16:18 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-10-07 02:00 Moving to PostGres Benjamin Stewart <[email protected]>
2002-10-07 02:37 ` [email protected]
2002-10-07 16:18 ` Neil Conway <[email protected]>

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