From: Gregory S. Williamson <gsw@globexplorer.com>
To: Fernando Garcia <cubafer@gmail.com>
Cc: pgsql-sql@postgresql.org
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> (raw)
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:
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 <gsw@globexplorer.com> 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" = 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:43734556223684784314229!
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: gsw@globexplorer.com, cubafer@gmail.com
Subject: Re: Como ejecutar una funcion insert en plpgsql....
In-Reply-To: <71E37EF6B7DCC1499CEA0316A2568328024BBB8B@loki.wc.globexplorer.net>
References: <71E37EF6B7DCC1499CEA0316A2568328024BBB8B@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