Re: ANSI SQL, CASE expression Conformance F262, F263 any info

>"Pavel Stehule" <pavel.stehule@hotmail.com> writes:
> > I can't find any information of syntax for ANSI Conformance F262, F263. 
>Has
> > somebody any information about this points: Extended CASE expression, 
>comma
> > separated predicates in simple case expression
>
>There are no such feature IDs listed in either SQL99 or SQL2003.  What
>are you reading?
>
>            regards, tom lane

First, I looked 
http://www.postgresql.org/docs/8.1/interactive/unsupported-features-sql-standard.html

I don't found any information on internet - only BNF syntax for SQL 2003.
http://savage.net.au/SQL/sql-2003-2.bnf.html#xref-CASE

SQL2003 has little bit different syntax for CASE.

example: BETWEEN
<between> := <row value> between_part2
<between_part2> := [NOT] BETWEEN [ASYMMETRIC|SYMMETRIC] <row value> AND <row 
value>
---------------------------
<simple_case> := CASE <row value> <simple_when_clause> [<else_clause>] END
<simple_when_clause := WHEN <when_operand> THEN <result>
<when_operand> := <row value> | <between_part2> | ....

so I can:
SELECT CASE EXTRACT(minute FROM when_col)   WHEN BETWEEN 0 AND 14 THEN 0   WHEN BETWEEN 15 AND 29 THEN 15   WHEN
BETWEEN30 AND 44 THEN 30   ELSE 45 END
 

this is extended CASE expression propably F262. About F263 I don't found any 
indicies. Maybe it's
SELECT CASE col WHEN 1,3,5,7,9,11 THEN false ELSE END

I looked into parser. F262 is usefull, but I am not sure if can be 
implemented. It's need refactoring gram.y or duplicate code for CASE, and 
maybe others - is possible share one operand in more expressions?

I see others ANSI or NON ANSI enhancing as much usefull: window function or 
autonomous transaction.

Regards
Pavel Stehule

_________________________________________________________________
Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/