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

"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 BETWEEN 30 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/