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