Postgres Pro
Downloads
Home   >   mailing lists

Re: Retrieve month from date - Mailing list pgsql-sql

From RPK
Subject Re: Retrieve month from date
Date
Msg-id 10105471.post@talk.nabble.com
Whole thread Raw
In response to Retrieve month from date  ("Rohit Khare" <rpk.general@gmail.com>)
Responses Re: Retrieve month from date  ("Rodrigo De León" <rdeleonp@gmail.com>)
List pgsql-sql
Tree view 
Thanks both of you,

I ran EXPLAIN command on above suggested query and got following result:

"Aggregate  (cost=2.77..2.79 rows=1 width=10)"
"  ->  Seq Scan on studentfeespayment  (cost=0.00..2.77 rows=1 width=10)"
"        Filter: (date_part('month'::text, (recieptmonthyear)::timestamp
without time zone) = 4::double precision)"

What does this mean? Can I optimize it better?

-- 
View this message in context: http://www.nabble.com/Retrieve-month-from-date-tf3617513.html#a10105471
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

pgsql-sql by date:

Previous
From: Dmitry Turin
Date:
Subject: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant
Next
From: "Rodrigo De León"
Date:
Subject: Re: Retrieve month from date