Re: Como ejecutar una funcion insert en plpgsql....

Fernando --

I have forwarded your message to the postgres SQL list where it started -- it is good practice to "cc" the list in
generalso 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
thatmight 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.....rememberI 
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
somethinin 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!