Обсуждение: Doubt in stored procedure

Поиск
Список
Период
Сортировка

Doubt in stored procedure

От
"satheesh Gnanasekaran"
Дата:
hi,
 
   iam a novice in postgresql. i want to insert a values  to a table using stored procedure. plz mail me  the sample codes and examples. thanks in advance
 
 
 
with regards,
Sathaa

Re: Doubt in stored procedure

От
Richard Broersma Jr
Дата:
i want to insert a values  to a table using
> stored procedure. plz mail me  the sample codes and examples. thanks in
> advance

This link has a few examples that might help:
http://www.postgresql.org/docs/8.1/interactive/plpgsql-expressions.html

This comes from the PostgreSQL manual.  I would be a very good resource to use.

Regards,

Richard Broersma Jr.

Re: Doubt in stored procedure

От
Richard Broersma Jr
Дата:
> This comes from the PostgreSQL manual.  I would be a very good resource to use.


OOPS.  I really meant, "IT would be a very good resource to use."  :-D

Re: [SQL] Doubt in stored procedure

От
"Jim C. Nasby"
Дата:
On Tue, Jun 20, 2006 at 11:55:03AM +0530, satheesh Gnanasekaran wrote:
> hi,
>
>   iam a novice in postgresql. i want to insert a values  to a table using
> stored procedure. plz mail me  the sample codes and examples. thanks in
> advance

Just create a plpgsql stored proc with an insert statement in it.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461