pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedDoubt in stored procedure
4+ messages / 3 participants
[nested] [flat]
* Doubt in stored procedure
@ 2006-06-20 06:25 satheesh Gnanasekaran <satheeshravikumar@gmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: satheesh Gnanasekaran @ 2006-06-20 06:25 UTC (permalink / raw)
To: pgsql-novice@postgresql.org.
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Doubt in stored procedure
@ 2006-06-22 14:26 Richard Broersma Jr <rabroersma@yahoo.com>
parent: satheesh Gnanasekaran <satheeshravikumar@gmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Richard Broersma Jr @ 2006-06-22 14:26 UTC (permalink / raw)
To: satheesh Gnanasekaran <satheeshravikumar@gmail.com>; pgsql-novice@postgresql.org
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Doubt in stored procedure
@ 2006-06-22 14:41 Richard Broersma Jr <rabroersma@yahoo.com>
parent: Richard Broersma Jr <rabroersma@yahoo.com>
0 siblings, 0 replies; 4+ messages in thread
From: Richard Broersma Jr @ 2006-06-22 14:41 UTC (permalink / raw)
To: Richard Broersma Jr <rabroersma@yahoo.com>; satheesh Gnanasekaran <satheeshravikumar@gmail.com>; pgsql-novice@postgresql.org
> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] Doubt in stored procedure
@ 2006-07-01 05:50 Jim C. Nasby <jnasby@pervasive.com>
parent: satheesh Gnanasekaran <satheeshravikumar@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Jim C. Nasby @ 2006-07-01 05:50 UTC (permalink / raw)
To: satheesh Gnanasekaran <satheeshravikumar@gmail.com>; +Cc: pgsql-novice@postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2006-07-01 05:50 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-06-20 06:25 Doubt in stored procedure satheesh Gnanasekaran <satheeshravikumar@gmail.com>
2006-06-22 14:26 ` Richard Broersma Jr <rabroersma@yahoo.com>
2006-06-22 14:41 ` Richard Broersma Jr <rabroersma@yahoo.com>
2006-07-01 05:50 ` Jim C. Nasby <jnasby@pervasive.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox