pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedmanipulating the database in plsql
3+ messages / 3 participants
[nested] [flat]
* manipulating the database in plsql
@ 2002-07-07 18:40 teknokrat <teknokrat@yahoo.com>
0 siblings, 2 replies; 3+ messages in thread
From: teknokrat@yahoo.com @ 2002-07-07 18:40 UTC (permalink / raw)
To: pgsql-sql
Is there any way to work with tables etc, in plsql? Can i get a get a
database handle to the local database? If not, is there any chance for
this to be implemented in the near future?
thanks
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: manipulating the database in plsql
@ 2002-07-08 15:51 Roberto Mello <rmello@cc.usu.edu>
parent: teknokrat <teknokrat@yahoo.com>
1 sibling, 0 replies; 3+ messages in thread
From: Roberto Mello @ 2002-07-08 15:51 UTC (permalink / raw)
To: teknokrat <teknokrat@yahoo.com>; +Cc: pgsql-sql
On Sun, Jul 07, 2002 at 11:40:19AM -0700, teknokrat wrote:
> Is there any way to work with tables etc, in plsql? Can i get a get a
Yes.
> database handle to the local database? If not, is there any chance for
> this to be implemented in the near future?
I don't know what you mean. A PL/pgSQL function is already part of the
database it belongs to. It doesn't need a handle.
-Roberto
--
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net/
http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer
All true wisdom is found in taglines.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: manipulating the database in plsql
@ 2002-07-08 16:36 Janning Vygen <vygen@gmx.de>
parent: teknokrat <teknokrat@yahoo.com>
1 sibling, 0 replies; 3+ messages in thread
From: Janning Vygen @ 2002-07-08 16:36 UTC (permalink / raw)
To: teknokrat@yahoo.com; pgsql-sql
Am Sonntag, 7. Juli 2002 20:40 schrieb teknokrat:
> Is there any way to work with tables etc, in plsql? Can i get a get
> a database handle to the local database? If not, is there any
> chance for this to be implemented in the near future?
I guess you mean plpgsql.
you dont need a database handle inside plpgsql. you just can do SQL
operations or do other stuff like inserting, updating and so on
(sometimes you need the plpgsql PERFORM statement). look at the
programmers guide about procedural languages (plpgsql.html)
janning
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-07-08 16:36 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-07 18:40 manipulating the database in plsql teknokrat <teknokrat@yahoo.com>
2002-07-08 15:51 ` Roberto Mello <rmello@cc.usu.edu>
2002-07-08 16:36 ` Janning Vygen <vygen@gmx.de>
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