Postgres Pro
Downloads
Home   >   mailing lists

questions in query on 7.1 and 7.2 - Mailing list pgsql-general

From Alex Cheung Tin Ka
Subject questions in query on 7.1 and 7.2
Date
Msg-id 008001c236a1$191eaaf0$6a44a8c0@alexpc
Whole thread Raw
Responses Re: questions in query on 7.1 and 7.2  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Tree view
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@vtc.edu.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

pgsql-general by date:

Previous
From: Curt Sampson
Date:
Subject: Re: Linux max on shared buffers?
Next
From: Stephan Szabo
Date:
Subject: Re: questions in query on 7.1 and 7.2