[SQL] Using case or if to return multiple rows

2007-07-11 Thread Ashish Karalkar
Hello all, I want to select data from two diffrent table based on third tables column somthing like: select case when t3.date='' then select * from table1 else select * from table 2 from table3 t3 where t3.date='x' Prob

Re: [SQL] linux

2007-07-11 Thread Andrej Ricnik-Bay
On 7/12/07, Mohd Ghalib Akhtar <[EMAIL PROTECTED]> wrote: how to download linux 7.3 image file(means os) ? Please, for the sake of people who use mailing systems that support threading start a new mail for a new topic. Don't just respond to one you spotted and change the subject. Highly ir

Re: [SQL] using EXECUTE on Selects

2007-07-11 Thread Radhika Sambamurti
Thanks! That worked. I really could'nt make sense of the documentation, the way it was worded. I tested it out and it works. Thanks again! Radhika > am Wed, dem 11.07.2007, um 12:41:21 -0400 mailte Radhika Sambamurti > folgendes: >> Hi, >> >> Here is my need: >> >> I have to select data by buil

Re: [SQL] using EXECUTE on Selects

2007-07-11 Thread A. Kretschmer
am Wed, dem 11.07.2007, um 12:41:21 -0400 mailte Radhika Sambamurti folgendes: > Hi, > > Here is my need: > > I have to select data by building up the where clause: > example: WHERE firm = 'nnn' > WHERE firm = 'nnn' AND symbol = 'bbb' > WHERE date BETWEEN 'startdate' AND 'endda

Re: [SQL] using EXECUTE on Selects

2007-07-11 Thread Andrew Sullivan
On Wed, Jul 11, 2007 at 12:41:21PM -0400, Radhika Sambamurti wrote: > I was hoping to write a function where I can build up my where clause > (dynamic sql) and use the EXECUTE command with it. But I just read that > the SELECT INTO has not been implemented for use with EXECUTE. > > Is there a way

Re: [SQL] using EXECUTE on Selects

2007-07-11 Thread Rodrigo De León
On 7/11/07, Radhika Sambamurti <[EMAIL PROTECTED]> wrote: Is there a way to select data using EXECUTE? FOR-IN-EXECUTE. See: http://www.postgresql.org/docs/8.2/static/plpgsql-control-structures.html#PLPGSQL-RECORDS-ITERATING ---(end of broadcast)

[SQL] using EXECUTE on Selects

2007-07-11 Thread Radhika Sambamurti
Hi, Here is my need: I have to select data by building up the where clause: example: WHERE firm = 'nnn' WHERE firm = 'nnn' AND symbol = 'bbb' WHERE date BETWEEN 'startdate' AND 'enddate' AND symbol = 'bbb' And so on. I was hoping to write a function where I can build up my whe

[SQL] using EXECUTE on Selects

2007-07-11 Thread Radhika Sambamurti
Hi, Here is my need: I have to select data by building up the where clause: example: WHERE firm = 'nnn' WHERE firm = 'nnn' AND symbol = 'bbb' WHERE date BETWEEN 'startdate' AND 'enddate' AND symbol = 'bbb' And so on. I was hoping to write a function where I can build up my whe

Re: [SQL] linux

2007-07-11 Thread A. Kretschmer
am Wed, dem 11.07.2007, um 6:04:51 -0700 mailte Mohd Ghalib Akhtar folgendes: > how to download linux 7.3 image file(means os) ? Please wait some years, the current stable linux version is 2.6.22.1. I inform you when Linux 7.3 is available... Andreas -- Andreas Kretschmer Kontakt: Heynitz: 0

[SQL] linux

2007-07-11 Thread Mohd Ghalib Akhtar
how to download linux 7.3 image file(means os) ? Take care Mohd.Ghalib Akhtar (India.M)9899868681 (Africa.M) +255787896861 - Original Message From: Tom Lane <[EMAIL PROTECTED]> To: Peter Eisentraut <[EMAIL PROTECTED]> Cc: pgsql-sql@postgresql.org Sent: Tuesday, July 10, 2007