pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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!






view thread (9+ messages)  latest in thread

Message-ID: <71E37EF6B7DCC1499CEA0316A2568328024BBB8B@loki.wc.globexplorer.net>
Permalink:  ../71E37EF6B7DCC1499CEA0316A2568328024BBB8B@loki.wc.globexplorer.net/
Also on:    postgresql.org/message-id/71E37EF6B7DCC1499CEA0316A2568328024BBB8B@loki.wc.globexplorer.net

 · 

reply

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