On Wed, Dec 15, 2010 at 11:38 PM, Scott Marlowe wrote:
> On Wed, Dec 15, 2010 at 8:12 AM, Alberto 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
> > occurs in the middle?
>
> Yes, pu
On Wed, Dec 15, 2010 at 8:12 AM, Alberto 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", "detail_invoic
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
On 15 December 2010 11:23, venkat 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
>
>
>
selec
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 documentos
On Wed, Dec 15, 2010 at 11:23 AM, venkat 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
>
>
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 :
> Dear All,
> How do i convert string to int
> select SUM(pan_1) from customers1 where name='101'
> When i run the ab
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
