o that with INTERVAL information with me?? pls guide me..
Also can I have link to some doucmentation where i can read about Date/Time
zone related theroy/functions??
thanks in advance..
regards,
Raman Garg
---(end of broadcast)---
TIP 6: Ha
one(-7:00)
Well, it worked for me now.. maybe some logic of neagative time zone is
there due to which our time calculation make the difference of two time
greater. :-?
Thanks for your descriptive and nice explanation...
Regards,
-- Raman
- Original Message -
From: "Richard Huxton" &l
;start_time=02:34:00" and
"send_before_time=00:05:00" above "between" query return FALSE and
current_time at US mountain zone (02:30) lies between that
I don't know WHY
Pls help.. in this. Also pls let me know if you need any other information.
With Regards,
Ram
customer_events
MY PROBLEM:
This query runs fine when i have
time_difference value like +5:30 +5:00 i.e. works fine for positive values
but failes for negative values i.e. -7:00, -6:00 etc
I don't know WHY WHY... pls help
I am helpless.
do reply back
Regards,
Raman Garg
Thanks Tom it worked for me...
yes I got it wrong.. thanks for the correction.
thanks a lot..
-- Raman
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Raman" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, January 28,
m customer_events"
here : time_difference - is my varchar column in the table customer_events.
This gives me errors " parse error at or near
"time_difference" at character 43 "
I tried to type cast it time_difference::text etc but it in vain.
Pls help me ... its realy urgent.
Thanks in advance
Raman Garg
hi,
I am new of postgre sql.im using cursors in pgsql and
getting tuples successfully returns in c++, but how
can i raise exception in the stored function?.pl
anyone help me.
This is my function :
CREATE or REPLACE FUNCTION
sp_test_validatePartnerCode(text)
RETURNS int4 AS
'
DECLARE
