Home > mailing lists

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

From	RPK
Subject	Re: Retrieve month from date
Date	April 20, 2007 16:13:42
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
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:

From: Dmitry Turin
Date: 20 April 2007, 15:56:48
Subject: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant

From: "Rodrigo De León"
Date: 20 April 2007, 16:33:34
Subject: Re: Retrieve month from date

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

Previous

Next