[SQL] Last serial number inserted

[Eduardo]

 How can I get the last id ( serial number ) inserted. My C code is :  

res = PQexec(conn,"insert into table1 (field1) values ('value1')");


table1: 
id SERIAL,
field1 VARCHAR(10) 


Thanks
Eduardo K

[SQL] Please delete my email

[Eduardo Palafox]

Hi!, I don't want to receive more emails from postgresql.

Please remove my email from your delivery list.

Thanks


  
_
Prefiero un día sin coche que sin Messenger
www.vivirmessenger.com

[SQL] Invitation to connect on LinkedIn

[Eduardo Schweigert]

LinkedIn
Eduardo Schweigert requested to add you as a connection on LinkedIn:
--

Marcin,

I'd like to add you to my professional network on LinkedIn.

- Eduardo

Accept invitation from Eduardo Schweigert
http://www.linkedin.com/e/z6cz6a-gb2fdtoy-n/XCcEdFwZmSzO1q19PFca3OmGtDdI_FirNbrhE9/blk/I2162188943_2/1BpC5vrmRLoRZcjkkZt5YCpnlOt3RApnhMpmdzgmhxrSNBszYOnPcQejwUcj8Scj99bSdLpj9mh6pgbPwScPsOc3AOd34LrCBxbOYWrSlI/EML_comm_afe/

View invitation from Eduardo Schweigert
http://www.linkedin.com/e/z6cz6a-gb2fdtoy-n/XCcEdFwZmSzO1q19PFca3OmGtDdI_FirNbrhE9/blk/I2162188943_2/39vcPgVe3wNczoNcAALqnpPbOYWrSlI/svi/


 
--
(c) 2010, LinkedIn Corporation

[SQL] Invitation to connect on LinkedIn

[Eduardo Schweigert]

LinkedIn
Eduardo Schweigert requested to add you as a connection on LinkedIn:
--

Marcin,

I'd like to add you to my professional network on LinkedIn.

- Eduardo

Accept invitation from Eduardo Schweigert
http://www.linkedin.com/e/z6cz6a-gb2i2cyo-r/XCcEdFwZmSzO1q19PFca3OmGtDdI_FirNbrhE9/blk/I2162188709_2/1BpC5vrmRLoRZcjkkZt5YCpnlOt3RApnhMpmdzgmhxrSNBszYOnPAMdPwUcj8Scj99bSdLpj9mh6pgbPwScPsOc3AOd34LrCBxbOYWrSlI/EML_comm_afe/

View invitation from Eduardo Schweigert
http://www.linkedin.com/e/z6cz6a-gb2i2cyo-r/XCcEdFwZmSzO1q19PFca3OmGtDdI_FirNbrhE9/blk/I2162188709_2/39vej0Te3wNczoNcAALqnpPbOYWrSlI/svi/


 
--
(c) 2010, LinkedIn Corporation

[SQL] Problema com função UPPER

[Eduardo Giovany Schweigert]

Pessoal estou com um problema para usar a função Upper, pelo que parece esta havendo uma incompatibilidade pois qd rodo o sql no linux ((Gentoo) funciona legal, agora no windows não ta trazendo os resultados. Em ambos os casos estou usando o Postgresql 
8.1 com PgAdmin 1.4.1, o sql é o seguinte.select * from pessoa  where UPPER( dsnome ) like'ADÃO%' limit 10 no linux, retorna as 10 linhas, no windows não
select * from pessoa  where dsnome like'Adão%' limit 10 retorna as 10 linhas tanto num qt noutro.Agradeço qualquer ajuda-- Eduardo Giovany Schweigert(51) 9183-7474

[SQL] Select very slow...

[Fernando Eduardo B. L. e Carvalho]

Table  1

create table person (

 doc text primary key,

 etc 

 city  text  );

   9 rows

   create table sales (

 doc text,

  etc .

  );

   30 rows

  select  p.city,count(*) from sales s, person p where s.doc = p.doc
group by p.city;

   Anyone help-me?





---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] C Functions

[Fernando Eduardo B. L. e Carvalho]

#include 
#include 

char *fernando(char *texto)
{
char *resultp = palloc(strlen(texto)+5);
*resultp = *texto;
strcat(resultp," mais");
return resultp;
}

gcc -shared fernando.c -o fernando.so

CREATE FUNCTION fernando (bpchar) RETURNS bpchar
  AS '/u/src/tef/fernando.so' LANGUAGE 'c';
CREATE
SELECT fernando ('Teste');
ERROR:  Memory exhausted in AllocSetAlloc(287341377)




---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]