questions in query on 7.1 and 7.2

From: "Alex Cheung Tin Ka" <tkcheung(at)vtc(dot)edu(dot)hk>
To: <pgsql-general(at)postgresql(dot)org>
Subject: questions in query on 7.1 and 7.2
Date: 2002-07-29 01:41:21
Message-ID: 008001c236a1$191eaaf0$6a44a8c0@alexpc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear All,
I have a table progress which contain "duration" text, "op_str_time" text, "form_status" integer, "ao_eamil" text and "ao_res_time" timestamp.

I have run the following query successful in pgsql 7.1 but failed in version 7.2.

select duration, op_str_time from progress where form_status = 4 and ao_email = 'abc(at)vtc(dot)edu(dot)hk' and ao_res_time is not null and extract(month from timestamp(op_str_time)) = 4;

Please anyone tell me why that happened.

Thanks,
Alex

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-07-29 02:13:52 Re: questions in query on 7.1 and 7.2
Previous Message Curt Sampson 2002-07-28 17:31:49 Re: Linux max on shared buffers?