From: | "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Brandon E Hofmann <Brandon_E_Hofmann(at)notes(dot)ntrs(dot)com> |
Subject: | Re: Question |
Date: | 2005-11-30 18:29:31 |
Message-ID: | 200511301029.31633.uwe@oss4u.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
How about reading the docs?
http://www.postgresql.org/docs/8.1/interactive/server-programming.html
is the chapter about stored procs
On Tuesday 29 November 2005 09:12, Brandon E Hofmann wrote:
> Does PostgreSQL include Stored Procedures supporting the CREATE PROCEDURE
> syntax. I notice pgAdmin III has a procedure section in addition to
> functions. I thought PostgreSQL implemented Stored Procedures before MySQL
> 5.0.
>
> I have a Sybase implementation with Stored Procedures that I want to
> convert to PostgreSQL. Do you have an example you can send me that shows a
> Stored Procedure returning a result set that can be displayed by Java?
>
> Any help you could provide would be greatly appreciated.
>
> Thanks,
>
> Brandon
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
--
UC
--
Open Source Solutions 4U, LLC 1618 Kelly St
Phone: +1 707 568 3056 Santa Rosa, CA 95401
Cell: +1 650 302 2405 United States
Fax: +1 707 568 6416
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2005-11-30 18:36:51 | Re: Why pgAdmin III guru suggests VACUUM in 8.1 |
Previous Message | John D. Burger | 2005-11-30 18:29:17 | Re: Finding uniques across a big join |