[GENERAL] Insert returning Npgsql

Good day every one . Im trying to make and insert returning with the connector Npgsql, where can i read more about the syntax of the insert string? or how to configure the Npgsql.command class. Regards Cesar Alvarez. begin:vcard fn:Cesar Alvarez n:;Cesar Alvarez title:Web Development Asesor

Re: [GENERAL] Transaction problem

What are you programing with?. are you using npgsql? Regards Cesar Alvarez. Hi everyone, I would like to know how can i do a simple transaction for this situation: I have n products in certain row of a table. When the user buys a product, the quantity of this product will be decreased

[GENERAL] cursors

Hello every one. im trying to make a Loop and i found in the manual this. FOR target IN query LOOP statements END LOOP Can i use cursor instead of the Query in the loop?? , this es more legible than using the open/fetch/close of the cursor. Regard Cesar Alvarez. begin:vcard fn:Cesar Alvarez

Re: [GENERAL] cursors

Thanks, what will be the syntax for that type of for? Pavel Stehule wrote: On 24/11/2007, Cesar Alvarez [EMAIL PROTECTED] wrote: Hello every one. im trying to make a Loop and i found in the manual this. FOR target IN query LOOP statements END LOOP Can i use cursor instead

[GENERAL] PIPELINED Functions

Hello every one, im working in a proyect that uses Oracle 10g, and nice concept i learn is the PIPELINED functions and Functions that return a Table, is there something alike in Postgres? begin:vcard fn:Cesar Alvarez n:;Cesar Alvarez title:Web Development Asesor and Software Enginner version

Re: [GENERAL] PIPELINED Functions

Reg Me Please wrote: Il Friday 09 November 2007 16:06:34 Cesar Alvarez ha scritto: Hello every one, im working in a proyect that uses Oracle 10g, and nice concept i learn is the PIPELINED functions and Functions that return a Table, is there something alike in Postgres? You do have

[GENERAL] INSERT RETURNING

Hello im working in a proyect in ORACLE 10g and one of the things i like is using the INSERT RETURNING with the parameters, im not sure that i read about postgres 8.2 suporting this feature... if its true where can i read more about it. regards Cesar Alvarez. begin:vcard fn:Cesar Alvarez n

[GENERAL] CHAR SETS

Good day everyone I got a question, what are the differences of SQL_ASCII and UTF8, witch one should i use?? regards Cesar Alvarez. begin:vcard fn:Cesar Alvarez n:;Cesar Alvarez title:Web Development Asesor and Software Enginner version:2.1 end:vcard ---(end

[GENERAL] blobs

hello every one is there a way to store pictures or executables in postgres?? Cesar Alvarez. begin:vcard fn:Cesar Alvarez n:;Cesar Alvarez title:Web Development Asesor and Software Enginner version:2.1 end:vcard ---(end of broadcast)--- TIP 6

[GENERAL] Store Procedures

the changes where made... can i do this with store procedures?? here are the 2 fields are: cajas INTEGER, unidades INTEGER, in the temporal table will be before_cajas INTEGER, before_unidades INTEGER, after_cajas INTEGER, after_unidades INTEGER, Regards Cesar Alvarez

Re: [GENERAL] Store Procedures

with the triggers and all that. Cesar Alvarez Web Development Asesor and Software Enginner.