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:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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! ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
