People,

I posted this to the general list with no response so this is the next 
step . .

I have a client that I have just changed over to PG 7.2.3 and despite 
the early teething problems things are going pretty well.  There are, 
however, a few more difficult problems to do with reporting via Crystal 
Reports that could easily be solved by Stored Procedures but these 
don't exist in PG.  The User Definable Functions, which would be able 
to do the job, are not visible to CR.

There is a white paper from Crystal Decisions about how Oracle Stored 
Procedures are packaged to enable them to be used by CR.

http://support.crystaldecisions.com/library/kbase/articles/c2010910.asp

Maybe the issue really lies with psqlODBC?

Does anyone know anything about this area?  If you do, do you think it 
might be possible to also package PG functions to look like stored 
procedures to CR?  If, so is anyone interested in doing the (paid) 
work?  I am quite happy for the result to be GPLd.

Thanks,

Phil.
-- 
Philip Rhoades

Pricom Pty Limited  (ACN  003 252 275)
GPO Box 3411
Sydney NSW	2001
Australia
Mobile:  +61:0411-185-652
Fax:  +61:2:8923-5363
E-mail:  pri@chu.com.au
----- End Forwarded Message -----

-- 
Philip Rhoades

Pricom Pty Limited  (ACN  003 252 275)
GPO Box 3411
Sydney NSW	2001
Australia
Mobile:  +61:0411-185-652
Fax:  +61:2:8923-5363
E-mail:  pri@chu.com.au

Wed, 30 Oct 2002 20:20:26 +1100
Philip Rhoades <pri@chu.com.au>
PG, Crystal Reports, Stored Procedures and User Defined Functions

7.3beta has much more powerful stored procedures.  Basically, you can
put function names in the FROM clause of a SELECT.  I recommend you try
that and then let us know exactly what is failing with Crystal Reports.
It may be just a syntax issue, or something more major.

---------------------------------------------------------------------------

Philip Rhoades wrote:
> People,
> 
> I posted this to the general list with no response so this is the next 
> step . .
> 
> I have a client that I have just changed over to PG 7.2.3 and despite 
> the early teething problems things are going pretty well.  There are, 
> however, a few more difficult problems to do with reporting via Crystal 
> Reports that could easily be solved by Stored Procedures but these 
> don't exist in PG.  The User Definable Functions, which would be able 
> to do the job, are not visible to CR.
> 
> There is a white paper from Crystal Decisions about how Oracle Stored 
> Procedures are packaged to enable them to be used by CR.
> 
> http://support.crystaldecisions.com/library/kbase/articles/c2010910.asp
> 
> Maybe the issue really lies with psqlODBC?
> 
> Does anyone know anything about this area?  If you do, do you think it 
> might be possible to also package PG functions to look like stored 
> procedures to CR?  If, so is anyone interested in doing the (paid) 
> work?  I am quite happy for the result to be GPLd.
> 
> Thanks,
> 
> Phil.
> -- 
> Philip Rhoades
> 
> Pricom Pty Limited  (ACN  003 252 275)
> GPO Box 3411
> Sydney NSW	2001
> Australia
> Mobile:  +61:0411-185-652
> Fax:  +61:2:8923-5363
> E-mail:  pri@chu.com.au
> ----- End Forwarded Message -----
> 
> -- 
> Philip Rhoades
> 
> Pricom Pty Limited  (ACN  003 252 275)
> GPO Box 3411
> Sydney NSW	2001
> Australia
> Mobile:  +61:0411-185-652
> Fax:  +61:2:8923-5363
> E-mail:  pri@chu.com.au
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Fri, 1 Nov 2002 19:18:59 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: PG, Crystal Reports, Stored Procedures and User Defined