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 7ED40DA5FB for ; Wed, 9 Nov 2005 21:01:46 -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 59748-06 for ; Thu, 10 Nov 2005 01:01:43 +0000 (GMT) X-Greylist: delayed 03:14:34.484396 by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 03CDCD92C7 for ; Wed, 9 Nov 2005 21:01:44 -0400 (AST) Received: from loki.globexplorer.com (loki.globexplorer.com [12.25.176.46]) by svr2.postgresql.org (Postfix) with ESMTP id 970ECF0B96 for ; Wed, 9 Nov 2005 21:47:11 +0000 (GMT) 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: Wed, 9 Nov 2005 13:47:08 -0800 Message-ID: <71E37EF6B7DCC1499CEA0316A2568328024BBB86@loki.wc.globexplorer.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [SQL] Como ejecutar una funcion insert en plpgsql.... Thread-Index: AcXlOaRtmCdLddAMSai7rBkkO3Tx9gAPRlE5 From: "Gregory S. Williamson" To: "Fernando Garcia" , 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/84 X-Sequence-Number: 23335 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:=09 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???? !DSPAM:437202c363872044317020!