| From: | "Ashish Ahlawat" <ahlawat(dot)ashish(at)gmail(dot)com> |
|---|---|
| To: | "Bruce Momjian" <bruce(at)momjian(dot)us> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Ken Johanson" <pg-user(at)kensystem(dot)com>, "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Using Control Flow Functions in a SELECT Statement |
| Date: | 2006-12-04 16:21:57 |
| Message-ID: | 682126990612040821p88a04d7la2a230901d118921@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi Team
I am unable to fetch data using following simple query it prompts following
error
*ORA: 00907: Missing right parenthesis*
Query :-
SELECT Name AS Title, StatID AS Status, RatingID AS Rating,
IF(NumDisks>1, 'Check for extra disks!', 'Only 1 disk.') AS Verify
FROM DVDs
*Table Structure :-*
CREATE TABLE DVDs (
Name VARCHAR(60) NOT NULL,
NumDisks INT NOT NULL ,
RatingID VARCHAR(4) NOT NULL,
StatID CHAR(3) NOT NULL
)
rows has been inserted with different numdisks numbers. pls help
warm R's
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma Jr | 2006-12-04 16:30:55 | Re: Using Control Flow Functions in a SELECT Statement |
| Previous Message | Travis Whitton | 2006-12-04 14:04:57 | Re: pg_xlog on separate drive |