X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AAB1CDADFD for ; Thu, 10 Nov 2005 10:04:43 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 11957-10 for ; Thu, 10 Nov 2005 14:04:39 +0000 (GMT) X-Greylist: delayed 16:17:32.271349 by SQLgrey- Received: from loki.globexplorer.com (loki.globexplorer.com [12.25.176.46]) by svr1.postgresql.org (Postfix) with ESMTP id BF869DADC6 for ; Thu, 10 Nov 2005 10:04:40 -0400 (AST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Subject: Re: Como ejecutar una funcion insert en plpgsql.... Date: Thu, 10 Nov 2005 06:04:43 -0800 Message-ID: <71E37EF6B7DCC1499CEA0316A2568328024BBB8B@loki.wc.globexplorer.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [SQL] Como ejecutar una funcion insert en plpgsql.... Thread-Index: AcXl+hZHpX5vHlJbQJeXr8fcDiUtVwABQJLh From: "Gregory S. Williamson" To: "Fernando Garcia" Cc: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/85 X-Sequence-Number: 23336 Fernando -- I have forwarded your message to the postgres SQL list where it started = -- it is good practice to "cc" the list in general so that others can = contribute / learn. If you could provide the version of postgres you are using that might = help, as there differences between 7.x and 8.x that might matter. I am at the very end of my day and too tired to be coherent -- perhaps = someone else can provide an elegant snippet of code ? If there's no response in the next few hours I'll give it try. ZzzzZzzzzZzzz G -----Original Message----- From: Fernando Garcia [mailto:cubafer@gmail.com] Sent: Thu 11/10/2005 5:23 AM To: Gregory S. Williamson Cc:=09 Subject: Re: [SQL] Como ejecutar una funcion insert en plpgsql.... thanks very much, jeje, my english its very rusry... i try explain to you what i can to do in the first = question.....remember I try!!!!! Well, I have one function what insert one record in one tabe (EJ: adduser(name,email,password)) How can I execute this function to prove this insertion......??? Welllllll, you understand somethin in muy very bad english!!! OK Thanks anywere.. On 11/9/05, Gregory S. Williamson wrote: > > > Fernando -- > > I am not sure about the first question -- my spansih is rusry. > > postgres does force all column, table and schema names (I think) to = lower > case (there have been recent long discussions about this on this list = IIRC). > If you want to preserve case put the column name in double quotes: > "ItemID" =3D ItemID > ItemID =3D itemid > > This applies both to the creation of a table and when referring to = that > table's columns. > > HTH, > > Greg Williamson > DBA > GlobeXplorer LLC > > -----Original Message----- > From: pgsql-sql-owner@postgresql.org on behalf of Fernando Garcia > Sent: Wed 11/9/2005 6:22 AM > To: pgsql-sql@postgresql.org > Cc: > Subject: [SQL] Como ejecutar una funcion insert en plpgsql.... > Hola a todo... necesito ejecutar una consulta Insert que realice en = pgsql > para ver si inserta correctamente en la tabla asociada, pero con = execute > me > da un error....alguien me puede decir como lo hago.... > yo trabajo con el editor postgresql manager pro.. > Gracias... > Ahh otra cosa: en otra consulta que realice pero que es un select al > principio me daba un error porque no encontraba la columna "ItemID" la > cual > porsupuesto existia, entonces a la columna le quite las mayusculas de = su > nombre quedando "itemid" y ya no me salio el error.....en postgres los > nombres de tablas y columnas deben ser siempre con minuscula???? > > >=20 > > > > !DSPAM:43734556223684784314229!