Re: [ADMIN] (Pl/SQL) Obtaining field names from record 'variable'

2007-12-12 Thread Allan Kamau
', and a simple query_rec.current_field will not do? Allan. - Original Message From: Elvis Henríquez <[EMAIL PROTECTED]> To: Allan Kamau <[EMAIL PROTECTED]> Cc: pgsql-admin@postgresql.org Sent: Wednesday, December 12, 2007 8:34:52 PM Subject: Re: [ADMIN] (Pl/SQL) O

Re: [ADMIN] (Pl/SQL) Obtaining field names from record 'variable'

2007-12-11 Thread Elvis Henríquez
Hi. You could do a query to the system catalogs (pg_attribute, for example) with your table name as the search criteria and the field names as the data; loop through that data to create your query in a string variable, and then EXECUTE it. While you are "looping" through the results of the system c

[ADMIN] (Pl/SQL) Obtaining field names from record 'variable'

2007-12-11 Thread Allan Kamau
Hi, I am writing a PL/SQL script to process data from a high dimensionality table where this table has most of it's field names encapsulating data. I would like to automatically loop through the fields of a RECORD variable (returned from a cursor) obtaining the field name and the field value. F

[ADMIN] PL/SQL dynamic update error

2007-07-25 Thread Eduardo Ferreira
I have a table with informations that change every month, and I have to update the monthly data in a new column. To do that, I try to find out wich months are being trated and I perform an update in my table for every month. So what I'm trying to do is to change the month column for a fixed name,

Re: [ADMIN] PL/SQL

2005-04-25 Thread Michael Fuhr
On Mon, Apr 25, 2005 at 10:38:25AM +0700, dedy wrote: > > I would like to ask, does pl/sql in oracle is same with the pl/sql in > postgreSQL See the PL/pgSQL documentation, in particular the "Porting from Oracle PL/SQL" section. Here are links to the documentation for the latest version of Pos

Re: [ADMIN] PL/SQL

2005-04-25 Thread Christopher Browne
Quoth [EMAIL PROTECTED] ("dedy"): > Hiii alll, > I would like to ask, does pl/sql in oracle is same with the pl/sql in > postgreSQL They are similar, though are certainly not identical. -- "cbbrowne","@","gmail.com" http://linuxdatabases.info/info/languages.html FLORIDA: We've been Gored by the b

[ADMIN] PL/SQL

2005-04-24 Thread dedy
Hiii alll, I would like to ask, does pl/sql in oracle is same with the pl/sql in postgreSQL Thank You Dedy Styawan Semarang - Central Java Indonesia |. . |L /| . _ . |\ _| \--+._/| . / ||\| Y J ) / |/| ./ J |)'( |` F`.'/ -<| F __

[ADMIN] PL/SQL Developer and TOAD

2002-10-02 Thread Elielson Fontanezi
Hi Folks!       I am interested to put TOAD and "PL/SQL Developer" (oracle shareware  tools) to work with PostgreSQL.     I have heard that TOAD can be used to manage PostgreSQL.     Who knows something about it?       I was uncapable of doing TOAD or "PL/SQL Developer" working with Postgre