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 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(at)gmail(dot)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(at)globexplorer(dot)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(at)postgresql(dot)org on behalf of Fernando Garcia
> Sent: Wed 11/9/2005 6:22 AM
> To: pgsql-sql(at)postgresql(dot)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!