Dear All,
How do i convert string to int
select SUM(pan_1) from customers1 where name='101'
When i run the above query i m getting function sum(character varying)
does not exist..
Please anyone can guide me..
Thanks
Hello
you can use a ::int for converting to integer. Or better - you can
alter column to integer. It will be faster and more correct.
Regards
Pavel Stehule
2010/12/15 venkat ven.tammin...@gmail.com:
Dear All,
How do i convert string to int
select SUM(pan_1) from customers1 where
On Wed, Dec 15, 2010 at 11:23 AM, venkat ven.tammin...@gmail.com wrote:
Dear All,
How do i convert string to int
select SUM(pan_1) from customers1 where name='101'
When i run the above query i m getting function sum(character varying)
does not exist..
Please anyone can guide me..
Hello,
I have a Function in PL/pgSQL and I need to translate it to SQL92, but
I'm stuck.
###
CREATE OR REPLACE FUNCTION pruebas(varchar, varchar, integer)
RETURNS SETOF personal AS
$delimiter$
BEGIN
PERFORM id from documentos WHERE descripcion = $1;
IF NOT FOUND THEN
INSERT INTO
On 15 December 2010 11:23, venkat ven.tammin...@gmail.com wrote:
Dear All,
How do i convert string to int
select SUM(pan_1) from customers1 where name='101'
When i run the above query i m getting function sum(character varying)
does not exist..
Please anyone can guide me..
Thanks
My question is regarding a potential situation:
I have a program that inserts values on 3 tables linked to each other. My
program is used in a POS. In this specific case, the program has to update
the tables header_invoice, detail_invoice and
payments_x_header_invoice.
In a normal operation, the
On Wed, Dec 15, 2010 at 8:12 AM, Alberto blob2...@gmail.com wrote:
My question is regarding a potential situation:
I have a program that inserts values on 3 tables linked to each other. My
program is used in a POS. In this specific case, the program has to update
the tables header_invoice,
On Wed, Dec 15, 2010 at 11:38 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Wed, Dec 15, 2010 at 8:12 AM, Alberto blob2...@gmail.com wrote:
Is there any way to make the 3 operations be one transaction for the
database, so that it keeps them all consistent in case a power shortage