Re: [PERFORM] How to SELECT

Yes I got Yaar Thanks a lot !!! (Dave Crooke,A. Kretschmer ) Regards, Angayarkanni Kajendran On Thu, Mar 11, 2010 at 12:44 PM, A. Kretschmer < andreas.kretsch...@schollglas.com> wrote: > In response to Angayarkanni : > > Hi, > > > > I am the beginner of pgpsql &

[PERFORM] How to SELECT

Hi, I am the beginner of pgpsql I need to select from two tables say T1,T2 by UNION when the value is from T1 the output should by a 1 and when the value from T2 the out put should be 2 when T1 Hits values should be 1 and when T2 hits the value should be 2 or when we use COALESCE(is exits v

Re: [PERFORM] sub-select in IN clause results in sequential scan

2009/10/29 Grzegorz Jaśkiewicz > > > On Wed, Oct 28, 2009 at 6:13 PM, Anj Adu wrote: > >> Postgres consistently does a sequential scan on the child partitions >> for this query >> >> select * from partitioned_table >> where partitioned_column > current_timestamp - interval 8 days >> where x in