Re: Using Control Flow Functions in a SELECT Statement

Поиск
Список
Период
Сортировка
От Ashish Ahlawat
Тема Re: Using Control Flow Functions in a SELECT Statement
Дата
Msg-id 682126990612040842s136366d5wa3461535f93bb544@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Using Control Flow Functions in a SELECT Statement  (Bricklen Anderson <banderson@presinet.com>)
Ответы Re: Using Control Flow Functions in a SELECT Statement  (Richard Broersma Jr <rabroersma@yahoo.com>)
Re: Using Control Flow Functions in a SELECT Statement  (Ragnar <gnari@hive.is>)
Список pgsql-sql
Дерево обсуждения

Hi Team

Thanks FOR your prompt response....But USING CASE issue still NOT resolved....Oracle prompts same error .

Team its a simple query but really instresting one...

Following data has been updated IN TABLE DVDs

INSERT INTO DVDs (Name, NumDisks, RatingID, StatID)

VALUES('Mash', 2, 'R', 's2'), ('View', 1, 'NR', 's1'), ( 'Show', 2, 'NR' , 's2'), ('Amadeus' , 1, 'PG' , 's2') , ('Falcon', 1, 'NR', 's2'),

('Africa', 1, 'PG', 's1'), ('Doc', 1, 'G', 's2') , ('Christmas', 1 , 'NR', 's1');

On 12/4/06, Bricklen Anderson <banderson@presinet.com> wrote:
Ashish Ahlawat wrote:
>
> 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
>

i. That's an Oracle error message.
ii. IF does not belong in an SQL query. Use CASE.


В списке pgsql-sql по дате отправления:

Предыдущее
От: Bricklen Anderson
Дата:
Сообщение: Re: Using Control Flow Functions in a SELECT Statement
Следующее
От: Richard Broersma Jr
Дата:
Сообщение: Re: Using Control Flow Functions in a SELECT Statement