From: Gregory S. Williamson <gsw@globexplorer.com>
To: Fernando Garcia <cubafer@gmail.com>
To: pgsql-sql@postgresql.org
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> (raw)
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" = ItemID
ItemID = 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????
!DSPAM:437202c363872044317020!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gsw@globexplorer.com, cubafer@gmail.com
Subject: Re: Como ejecutar una funcion insert en plpgsql....
In-Reply-To: <71E37EF6B7DCC1499CEA0316A2568328024BBB86@loki.wc.globexplorer.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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