Re: [SQL] Difference between these two queries ?

2010-06-06 Thread Nilesh Govindarajan
Thank you all for your explaination. -- Nilesh Govindarajan Facebook: nilesh.gr Twitter: nileshgr Website: www.itech7.com Cheap and Reliable VPS Hosting: http://j.mp/arHk5e -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http

[SQL] Difference between these two queries ?

2010-06-05 Thread Nilesh Govindarajan
possible that they have different execution times ? -- Nilesh Govindarajan Facebook: nilesh.gr Twitter: nileshgr Website: www.itech7.com Cheap and Reliable VPS Hosting: http://j.mp/arHk5e -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http

Re: [SQL] LIMIT problem

2010-04-30 Thread Nilesh Govindarajan
returns. If I'm wrong please correct me. -- Nilesh Govindarajan Site & Server Administrator www.itech7.com मेरा भारत महान ! मम भारत: महत्तम भवतु ! -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

[SQL] Help me with this multi-table query

2010-03-25 Thread Nilesh Govindarajan
g. I want nc and cc in just one query. How to ? -- Nilesh Govindarajan Site & Server Administrator www.itech7.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] Check type compatibility

2010-03-06 Thread Nilesh Govindarajan
table2.att2)) THEN >... > ELSE >... > END IF; > > Thanks > > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > Explain in more detail. -- Nilesh Govindarajan Site & Server Administrator www.itech7.com