From: "A. Kretschmer" <[EMAIL PROTECTED]>
First, please create a new thread for a new question.
Sorry, ok i create new thread
Rewrite the line
v_output := select ((v_timeout - v_timein) ...
to:
select into v_output ((v_timeout - v_timein) ...
(not tested)
please tested your answer
Dear Expert,
I have a function to getting time interval bellow :
create or replace function scmaster.pr_gettimeinterval(time without time zone,
time without time zone, numeric(5,2)) returns char(10) As '
declare v_timeinalias for $1;
v_timeout alias for $2;
v_timebreak alia
DONE
thank you very much.
Best Regards,
Alam Surya
- Original Message -
From: "Sam Mason" <[EMAIL PROTECTED]>
To:
Sent: Monday, November 10, 2008 18:50
Subject: Re: [GENERAL] Get interval in months
On Mon, Nov 10, 2008 at 12:06:04PM +0700, dbalingl
>From: "A. Kretschmer" <[EMAIL PROTECTED]>
>
>select into v_output ((v_timeout - v_timein) ...
>
>Done, works for me.
>
ok, maybe you mean :
select ((v_timeout - v_timein) - interval ''v_timebreak minutes'') into
v_output;
and then if i try to execute my function on pgAdmin with command :
s
Dear Expert,
I'm sorry for my newbie question, I have a dificulty to load image file from
field OID type on PostgreSQL with Borland Delphi 7.
I would like to showing image file with TDBImage component to Delphi Form, but
the image file can't display, any sugestion for me about how can i do to
ly connected to
PostgreSQL Database using Zeos Component.
Any sugestion for me bro ?
many thanks and regards,
dbalinglung
>- Original Message -
>From: "Julius Tuskenis"
>Cc:
>Sent: Tuesday, December 30, 2008 2:46 PM
>Subject: Re: [GENERAL] Load Image File
Ok, I'll try your sugestion, many thanks bro.
Regards,
dbalinglung
>- Original Message -
>From: "Julius Tuskenis"
>To: "dbalinglung"
>Sent: Tuesday, December 30, 2008 5:39 PM
>Subject: Re: [GENERAL] Load Image File From PostgreSQL DB
>
what for of the syntax command +1 on order by ? maybe just wrong to given
result about the error query on order by, it's BUG ?
dbalinglung
DataproSoft Developer
- Original Message -
From: "Louis-David Mitterrand"
To:
Sent: Wednesday, January 14, 2009 5:46 PM
Su
dear guys
how to i saving my picture file into table
?
thanks
regards
Alam Surya
