>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
am Mon, dem 10.11.2008, um 13:13:05 +0700 mailte dbalinglung folgendes:
> >From: "A. Kretschmer" <[EMAIL PROTECTED]>
> >
> >First, please create a new thread for a new question.
> >
> >
>
> Sorry, ok i create new thread
his is still the old thread, see the References-Headers.
> >select into v_o
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
am Mon, dem 10.11.2008, um 12:06:04 +0700 mailte dbalinglung folgendes:
> Dear Expert,
First, please create a new thread for a new question.
>
> I have a function to getting time interval bellow :
>
> create or replace function scmaster.pr_gettimeinterval(time without time zone,
> time with
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
James,
It is not good practice to delete an account with out first transfering the
amount in that account to another account. You will also need to make sure the
account has a zero balance before deleting it. You will also need to log the
transactions if funds are moved between accounts wit
There is some my publications about SART AML System, where is more
detailed described all this things (and more) that I wrote below.
http://www.analyticsql.org/documentation.html
Regards,
Blazej Oleszkiewicz
2008/9/4 Blazej <[EMAIL PROTECTED]>:
> Hi Artacus
>
> 2008/9/4 Artacus <[EMAIL PROTECTED
Hi James,
There is some my publications about SART AML System based on banking
General Ledger (OLAP Data Warehouse and Chart of Accounts as dimension
with 60 000+ items) - may be helpful.
http://www.analyticsql.org/documentation.html
http://www.analyticsql.org/files/AITM-MoneyLaundering.pdf
Rega
"Andrus" <[EMAIL PROTECTED]> writes:
>> The IN-pullup code runs before constant-simplification does, so it
>> doesn't see that as a simple join condition.
> Seems serious design flaw.
> How to change expression parser so that contant parts of expressions are
> removed before IN-pullup?
It would
The IN-pullup code runs before constant-simplification does, so it
doesn't see that as a simple join condition.
Seems serious design flaw.
How to change expression parser so that contant parts of expressions are
removed before IN-pullup?
Andrus.
--
Sent via pgsql-general mailing list (pgs
On Sat, Oct 25, 2008 at 6:12 PM, Ati Rosselet <[EMAIL PROTECTED]> wrote:
> I'm still getting a lot of these entries in my eventlog whenever I have a
> reasonably large amount of logging:
>
> Event Type:Error
> Event Source:PostgreSQL
> Event Category:None
> Event ID:0
> Date:
Michelle Konzack wrote:
Am 2008-11-08 19:07:35, schrieb Scott Marlowe:
No, your histrionics aside, it's the way this list works by default,
and for good reason. If you need it to work differently, there's a
setting which has been pointed out to you at two times now. Please
take responsibility
On 09/11/2008 04:32, Uwe C. Schroeder wrote:
> Actually it's polite and pretty much standard to hit "reply all" and I for
> one
> appreciate it when I'm kept on CC, just because originally I was interested
> in the topic discussed and I might miss the response otherwise.
There's also the fact t
13 matches
Mail list logo
